[eluser]Unknown[/eluser]
Hi everyone,
I have a small problem with like.
this code:
Code:
$this->db->select('generic_file.name, generic_file.uid')
->from('generic_file')
->where('generic_file.folder', 'results')
->like('generic_file.name', $search_text);
generates this query when searching for text with _, % characters in it(searched a_ in this example):
Code:
SELECT "vav"."generic_file"."name", "vav"."generic_file"."uid"
FROM "vav"."generic_file"
WHERE "vav"."generic_file"."folder" = 'results'
AND "vav"."generic_file"."name" LIKE '%a!!_%' ESCAPE '!'
where obviously there should be only one exclamation mark.
Am I doing something wrong?
I am running the latest CodeIgniter version and PostgreSQL 9.1 database