Alternative for LIKE syntax

1

Hello, I am trying to use the LIKE ‘a%’ sign to create a chart that only shows certain data that begins with the first few letters. It is correct SQL syntax just doesn’t seem to work in Grafana. Can anyone help with an alternative. Below Is query. I want to replace ‘ARCHDB501’ with anything that starts with ‘ARCHDB%’

SELECT count(“value”) FROM “autogen”.“MailBox_Size” WHERE (“MailBox_DataBaseName” = ‘ARCHDB501’) AND $timeFilter

Thank you

1 Like
2

Create a variable and use in command in sql instead of like operator

3

Yes, it’s crazy how difficult it is to find the info.

4

Welcome

What is the issue you are facing?

5

hi malamgir, so if i am just trying to do this relatively easy thing with LIKE syntax to see if the field contains the word world, what do i need to do? Thanks in advance…

WHERE field LIKE ‘%world%’