How to use regexp in Model::find()

Question

How to use regexp in Model::find()

ohmcoe Oct '14

Created Oct '14	Last Reply Oct '14	Replies 2	Views 823	Votes 0

ohmcoe 1.4k

Oct '14

How to use regexp in Model::find()

when use command like this SELECT FROM user WHERE username regexp 'contest3_.'

I try User::find("username regexp 'contest3_.*'");

it have error.

Syntax error, unexpected token IDENTIFIER(regexp), near to ' 'contest3.'', when parsing: SELECT [PSUOJ\Models\User]. FROM [PSUOJ\Models\User] WHERE username regexp 'contest3.*' (89)

Gareth Williams · Answer 1 · 2014-10-15T01:06:00-07:00

I'm not sure if Phalcon supports regexp, but in this example, couldn't you just use:

User::find("username like 'contest3_%'");

RompePC · Answer 2 · 2014-10-15T05:05:07-07:00

Gareth is right (and I also use it), but you are also wrong with your clause. I reproduced your SQL with a DB I have, and also gives me error when using *. You only have to write contest_3. Try it.