How can I search (case-insensitive) in a column using LIKE wildcard? September 22, 2022 by Tarik I’ve always solved this using lower: SELECT * FROM trees WHERE LOWER( trees.title ) LIKE '%elm%'