Query for InfluxDb to select a range of tag keys

#1

Hi there, I am trying to select a range of values with a condition. My condition is select the values where the “key” of this values is in the range between Key>1 and key<200. My Influx database has 2 measurements, field “value” and a tag field “key”.

I need a query to select this values in my key range to visualize them into Grafana.

I already try something like

select * from where “key” > ‘1’ and “key” < 200

but It is not working. Nevertheless I can select the values from one single key:

select value from leuko where “key” = ‘2’

That is working. How could I do the same but just not for the values with the key ‘2’ but also for all the values between ‘2’ and ‘200’? Thanks