RegEx not containing a string

[Ruslan Zasukhin]

On 7/20/05 1:37 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:

> Hello to all,
> 
> can anyone help me how to exclude a string in a regex?
> 
> e.g. find all records where name contains "Smith" but doesn't contain "John"
> SELECT * from tb_persons WHERE name REGEX 'Smith !John'

I remember REGEX allow disable set of chars.

            ^[abc]

May be you should do it as

     SELECT * from tb_persons WHERE name REGEX 'Smith' and NOT REGEX 'John'

Although this is worse because require 2 scan of table column


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