Another Neophyte SQL Question
Bart Pietercil
bart.pietercil at gmail.com
Thu Feb 15 13:13:57 CST 2007
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
More information about the Valentina
mailing list