Another Neophyte SQL Question

[Chuck Pelto]

Hi Bart,

On Feb 15, 2007, at 12:13 PM, Bart Pietercil wrote:

> Probably this is what you are after.
>
> http://www.valentina-db.com/dokuwiki/doku.php? 
> id=paradigma:public:en:documentation:vsql:reference:select:set_retenti 
> on_check
>
> Mind you , still good to check the index by words flag for the field

So, I could use the IN function and write the SQL search verbiage as  
follows....

WHERE f1 IN (value1, value2....valuex)

That's nice to have learned. It'll make the string much easier to  
build....I hope....

Regards,

Chuck



> On 15-feb-07, at 19:55, Chuck Pelto wrote:
>
>> Greetings,
>>
>> If I have multiple search criteria in a textual field, how would I  
>> have to write the SQL query?
>>
>> Case in point, I have a VText field with scads of text in it, say  
>> from on-line newspaper articles.
>>
>> I want to find all the articles that mention "strawberries" and  
>> "gun laws".
>>
>> Which is the proper syntax to use?
>>
>> "....WHERE f1 LIKE %'" + value1 + "'% AND LIKE %'" + value2 +  
>> "'%" // mentioning the field only once for all values to be  
>> checked for
>>
>> or
>>
>> "....WHERE f1 LIKE %'" + value1 + "'% AND f1 LIKE %'" + value2 +  
>> "'%" // mentioning the field for every value to be checked for
>>
>>
>> Regards,
>>
>> Chuck
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>