+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: Strange WHERE (/showthread.php?tid=37282)
Strange WHERE - El Forum - 01-04-2011
[eluser]nertos[/eluser]
Hi,
how can I do this in CI Model:
select id from table where text !~ 'ab([a-z][a-z] )*'
I try like this:
$this->db->where('text !~','ab([a-z][a-z] )*');
but it doesn't work?
Any ideas?
Strange WHERE - El Forum - 01-04-2011
[eluser]Nick_MyShuitings[/eluser]
I'm not even sure that what you have is valid SQL, but on weird odd queries like that one, and ones with complex where (many clauses) or (many clauses) its often easier to just write out the query