Hi, I'm using this for example: SELECT * FROM ADRESSEN WHERE vorname LIKE <!--#sqlvar expr="vorname + '%'" type=string --> AND name LIKE <!--#sqlvar expr="name + '%'" type=string --> AND organisation LIKE <!--#sqlvar expr="organisation + '%'" type=string --> AND strasse LIKE <!--#sqlvar expr="strasse + '%'" type=string --> AND plz LIKE <!--#sqlvar expr="plz + '%'" type=string --> AND ort LIKE <!--#sqlvar expr="ort + '%'" type=string --> AND tel LIKE <!--#sqlvar expr="tel + '%'" type=string --> AND fax LIKE <!--#sqlvar expr="fax + '%'" type=string --> ORDER BY <!--#sqlvar sortier type=string --> On 30 Jun 1999, CURTIS David wrote:
Friends of Zope, I am a newbie who wants to know how to search for for data on a MySQL database using the SQL LIKE command. I used the tutorial and found it helpful but It show how to search for exact matches only. I suppose this is easily done, Any ideas?
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
Gruß Joachim Schmitz WWW-Consultant email: js@ac-copy.net tel: +49-241-89491-0 fax: +49-241-89491-29