How can I use the content of a cell in a mySQL query?
I am using Supermetrics to bring data from mySQL to Google Sheets, but I have a problem. i want the query to have a filter depending on a field. For example, something like where field1='[content of cell A2]'.
How can I do that?
But I am not able to get it working.
select * from tabla where string_field=%RANGE:'Test sheet'!A1%
returns a syntax error.
How can it be done? Thanks a lot