Books containing the word: SPANISH

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