title: How to search the string in query with case insensitive on Clickhouse database?
body: <p>I am developing site using PHP and backend ClickHouse database. When i using like queries , it is not supporting case-sensitive words. </p>
  
  <pre><code>select id,comments from discussion where  comments LIKE "%Data not reflect%";
  </code></pre>
  
  <p>Is there any way to search case-insensitive words?</p>