Search terms

[Ruslan Zasukhin]

On 3/8/06 2:33 PM, "Martin Wright" <martin at kinetix.co.uk> wrote:

Hi Martin,

> Is there an easy way of using a search term such as:
> 
> "camera AND lens NOT canon NOT nikon"
> Or 
> "camera +lens -canon -nikon"
> 
> Maybe using RegEx?
> Do I need to build the SQL statement by looping through the words?

Using in which field type ?

You mean find record where some FIELD value (Text or VarChar)

    contains words camera AND lens but NOT (cannon and nikon)?

I think IF you have index by words on that field you can do simply

    WHERE f in ('camera', 'lens') and f not in ('cannon', 'nikon')


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