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?

Hi. The following works fine on demo :

select * from weather where skyCover like 'oV%';

If you need case-insensitive then use ILIKE . Doc : https://questdb.io/docs/reference/operators/pattern-matching/#likeilike

Oh thanks. I had some issue in my data.. Working now.

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 🙂