Another Neophyte SQL Question

[Bart Pietercil]

Oops, I think I answered a bit to promptly( without good reading)


Probably this is what you are after.

http://www.valentina-db.com/dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vsql:reference:select:set_retention 
_check

Mind you , still good to check the index by words flag for the field

hth

Bart Pietercil



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