SQL Database Connector Plugin : Like query syntax error

I am trying to use a like query to search in a column. When I add parameter in bubble plugin it shows syntax error which should not be the case.Here is the screenshot for query and error.

If anyone could correct the syntax or have another way to implement this query, that would be very helpful.


@joeyg provide the solution

Try this:

select * from…where industry like ? limit 10;

$1 Name industry type=text

Then use %% (no quotes) as the parameter when you call the API. You can test the syntax by entering %% in the Test value and pressing the “Initialize this query” button.

This topic was automatically closed after 70 days. New replies are no longer allowed.