REGEX search

[Ruslan Zasukhin]

On 12/27/09 4:48 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> 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?

Valentina uses IBM ICU library as you,
OS X itself  also btw.


I have go to Googl, and type  ICU REGEX.
Search have bring me to

http://userguide.icu-project.org/strings/regexp


It seems you correctly using \b

May be problem in escape of string with query?


-- 
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]