I write sql like:
select * from <table_name>
where <column_name> like pattern;
but it shows an error:
I do not know why it cannot use "like" operator.....
Thanks!
I write sql like:
select * from <table_name>
where <column_name> like pattern;
but it shows an error:
I do not know why it cannot use "like" operator.....
Thanks!
Hi @coconion
You would get the same error if you used another tool. The problem is likely that your column is not a string.
But post "Diagnostic Info" from Admin > Troubleshooting, and which database type you're querying.