Use Variable Grafana In Query With Like

I'm trying to create a query in GRAFANA with LIKE using the internal variables of the tool, but it informs the value of the variable with '' and this is generating an error in the

Solution 1:

How about this:

select count(*) from table_name where column_name like concat ('%', $VARIABLE, '%') LIMIT 1