REGEX search

jda jda at his.com
Sun Dec 27 08:48:55 CST 2009


Hi Ruslan,

I'm trying to get a regex search by word boundary to work -- it should be simple, but it's not. This search for the word "the" fails:

Select * from theTable where theField REGEX '\bthe\b'

If I do this

Select * from theTable where theField REGEX 'the'

it works, but of course it finds any word with that substring in it.

What is the correct syntax?

Thanks.

Jon
Sonny Software


More information about the Valentina mailing list