Ajay Pilaniya

12/16/2022, 9:01 AM
Hi I was trying to execute a SELECT query to search a text column using
WHERE name LIKE '%test%
but this query is not returning any results. Does quest supports LIKE query? I am unable to find any documentation on it. Also how can I tell this query to ignore case sensitivity?

Bolek Ziobrowski

12/16/2022, 9:06 AM
Hi. The following works fine on demo :
select * from weather where skyCover like 'oV%';
If you need case-insensitive then use ILIKE . Doc :

Ajay Pilaniya

12/16/2022, 9:08 AM
Oh thanks. I had some issue in my data.. Working now.

javier ramirez

12/16/2022, 9:08 AM
Bole beat me to it XD. I just tried both with Symbol and String columns using Like and iLike and confirm it seems to work as expected 🙂