[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