[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