How to use LIKE Query with Codeigniter ?
You can use this query:
SELECT * FROM table WHERE field LIKE ?
And bind with
%search% instead of
You should be aware that this query will be slow in MySQL. You might want to look at free-text search instead (Lucene, Sphinx, or MySQL's built-in free-text search functions).