[V4MD] Search field parsing

[Ruslan Zasukhin]

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


> Just 1 field - such as:
> 
> "camera len*" and canon or nikon
> 
> The search will be done on a DB 'text' field which has index by word selected.
> 
> Martin
> 
>> -----Original Message-----
>> From: valentina-bounces at lists.macserve.net
>> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ivan Smahin
>> Sent: 03 April 2006 17:58
>> To: Valentina Developers
>> Subject: Re: [V4MD] Search field parsing
>> 
>> 
>> On Apr 3, 2006, at 7:52 PM, Martin Wright wrote:
>> 
>>> Hi Ruslan
>>> 
>>> Can you give me any advice on how to convert a search term into a
>>> valid SQL statement.
>>> The search field may have:
>>> 
>>> camera and lens     (AND search)

    WHERE fld = 'camera' AND fld = 'lens'


>>> camera or lens       (OR search)

    WHERE fld = 'camera' OR fld = 'lens'


>>> "camera lenses"     (phrase search)

        WHERE fld = 'camera lens'

>>> "camera lens*"       (wildcard + phrase)

    WHERE fld LIKE 'camera lens%'


>>> ... And any combination of the above.
>>> 
>> 
>> So some single string-based field may contain these words?
>> Or you mean two different fields?

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