Strange WHERE

[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?

[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