2808 explained code solutions for 75 technologies


clickhouseCase insensitive search on text column


SELECT * FROM tbl WHERE lowerUTF8(text) LIKE '%search%';ctrl + c
tbl

name of the table to search in

text

name of the text column to search on

lowerUTF8(

will lower-case column values

'%search%'

substring to search for