RegExp problem

[sbroad]

This particllar expression for regex in PHP /:::.s./ will search a file of my just fine. The 's' is what I am looking for and it must being with :::.

This will not work in MySql REGEXP. Does anyone know of a replacement?

[ultraslacker]

I don't understand the problem.

Why can you not use REGEXP '^:::.s.' ?

[sfullman]

So sounds to ME like you're looking for S'es but which must begin with :::.

Seems to me you might just have to use two operations, I don't know of any way to convey that english equivalent using regexp (you can always find a string in regex but you may not be able to 'express' a string :-)

/:::.s/i

you could also use if(regexp(),1,0) AS fieldName, and then sort or do something based on the value of that expression.

Sam