ActiveRecord, Like, ESCAPE problem

ActiveRecord, Like, ESCAPE problem - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: ActiveRecord, Like, ESCAPE problem (/showthread.php?tid=51359)

ActiveRecord, Like, ESCAPE problem - El Forum - 05-01-2012

[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