REGEX search

[Ivan Smahin]

Hello jda,

Sunday, December 27, 2009, 4:48:55 PM, you wrote:

> 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
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina


Try following:
Select * from theTable where theField REGEX '\\bthe\\b'

It works for me

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com