Questions about sql on metabase

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.....

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.