REGEX search for whole line

[Ruslan Zasukhin]

On 21/6/07 5:44 PM, "jda" <jda at his.com> wrote:

>>>  From the ICU docs it looks like this should work
>>> 
>>>    ...WHERE REGEX '^second line$'
>> 
>> Yes seems correct.
>> 
>>>  but it doesn't (it works if the only words in the field are 'second line').
>>> 
>>>  What would be the correct syntax?
>> 
>> Does your field is indexed by words ?
>> 
> 
> Hi Ruslan,
> 
> Yes, they are. But REGEX ignores indices, no?

Not always.

LIKE and REGEX can use INDEX SCAN if they see that operation is analog of
    START WITH.


I have to think more. May be you need it as

   ...WHERE fld REGEX '.*^second line$.*'

Because in your case it sounds FROM START to END,
But you want find such line that have OTHER text around.



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