How to search the string in query with case insensitive on Clickhouse database?

I am developing site using PHP and backend ClickHouse database. When i using like queries , it is not supporting case-sensitive words.

select id,comments from discussion where  comments LIKE "%Data not reflect%";

Is there any way to search case-insensitive words?

Answer

There’s no ILIKE operator. I think you can use lowerUTF8().

select id,comments from discussion where lowerUTF8(comments) LIKE '%Data not reflect%';

However, might be performance heavy as it will have to convert all comments values to lowercase.