codeignitercodeigniter-datamapper

How to use like clause in code iginiter query() WITH BIND PARAMS?

How to use like clause in code iginiter query() WITH BIND PARAMS?

Eg: When I use 

$query = 'SELECT mycol FROM mytable WHERE name LIKE %?';
$name = 'foo';
$db->this->query($query,array($name));
//the clause generated
//SELECT mycol FROM mytable WHERE id LIKE '%'foo'%' 
//I expected this
//SELECT mycol FROM mytable WHERE id LIKE '%foo'

I don't to put param values inside query and use like below: $query = 'SELECT mycol FROM mytable WHERE name LIKE '%foo';

Also I can not use $this->db->like() function as my query consists of: INSERT IGNORE and INSERT INTO table SELECT col FROM table2;

Please suggests? Thanks,

Solution 
  • $query = 'SELECT mycol FROM mytable WHERE name LIKE ?';
$name = '%foo';
$this->db->query($query,array($name));