How to choose different MySQL table according to the $__timeFilter(recordtime)?

Grafana MySQL
1

There’s a large amount of data saved in MySQL, so I create one table each day, like this “RSSI_20190228”, “RSSI_20190301”, “RSSI_20190302”, …

Here is the problem. I don’t know how to dynamically change the table name according to the $__timeFilter(recordtime).
The “Edit SQL” is like this
SELECT
$__time(recordtime),
rssi as value,
“nana” as metric
FROM rssitable
WHERE $__timeFilter(recordtime)
ORDER BY recordtime ASC

2

I recommend to use better DB design: single table and create partitioning schema based on recordtime column.