Books containing the word: FRENCH

Original String: french, Search: french. - french. SELECT * FROM books WHERE LOWER(title) LIKE LOWER("%french%") AND visible = '1'.