REGEX search

[Ruslan Zasukhin]

On 12/28/09 1:17 PM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> 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

So, as I have told, we need escaping of value ...

Thank you, Ivan.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]