[Zope-DB] zSQL method question

Marc Stein mstein@egrad.com
Sat, 1 Mar 2003 12:58:11 -0500

I apologize if this is a particularly stupid question, but...

I want to search against a text field in MySQL using a zSQL method such that
my search query is wrapped in % wildcard characters.

select * from xyz where
<dtml-sqltest search_query column=txCriteria op=like type=string>

In the above I want search_query to actually be %search_query%.  I'm sure
that there is some simple way to do this, I just haven't been able to figure
it out.

Any assistance would be greatly appreciated.

Marc Stein