Hey,
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.
Regards
Chirag
@joeyg provide the solution
Try this:
select * from…where industry like ? limit 10;
Parameters
$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.
