How to search for the last chracasters in a grafana query?

Hi everyone.
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 ??