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