I am a new user in Grafana and I would like please to have a query that returns a variable having “CA” at the END of its name.
I was using the SEARCH key code but it seems that it returns any result containing those characters while I am only interested in the last two characters.
As an example, I wrote this query :
SELECT cmts_device SEARCH CA
And it shows me this as a result
As you can see, it returns some values like : “CAE1CC”, “CAE2CC”, “CAR1CC” which end by “CC” not the “CA”.
How can I fix this please and filter those results ??