Hy guys,
I have a problem with like query.
I use $this->db->like('field', 'value');
All works well but when 'search string' contain 'and' doesn't work.
In this case my search string is 'Health and Safety'. As you can see below, after 'and' word from string exists one more whitespace.
This is what it trying to do.
"WHERE c.course_title LIKE '%Health and Safety%' ESCAPE '!'"
I think this is for security but how can a solve this problem. Cuz my query doesn't works with two whitespaces.
Thanx
