[V4MD] IN or LIKE?

[Ruslan Zasukhin]

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

>> Is there any reason why
>> 
>> WHERE ('derma' IN ('tbl_subsections.content_xml'))
>> 
>> Doesn't find any results but:
>> 
>> WHERE (tbl_subsections.content_xml LIKE '%derma%')
>> 
>> Does find results?
> 
> We are talking about v2 ?
>>> YES V2.

Because 

    WHERE ('derma' IN ('tbl_subsections.content_xml'))

Search for EXACT match


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