2006/1/21, Mike Sarahan <[EMAIL PROTECTED]>: > > This sure looks right to me, > > 1/Select : SELECT searchtable.id, searchtable.galleryterms, > searchtable.imageterms, searchtable.alt__id FROM searchtable WHERE > ((searchtable.galleryterms LIKE '%toronto%') OR (searchtable.imageterms > LIKE '%toronto%')) > > Thinking that the OR might be confusing it somehow, I reduced the > complexity to one section: > > 1/Select : SELECT searchtable.id, searchtable.imageterms, > searchtable.alt__id FROM searchtable WHERE (searchtable.imageterms LIKE > '%2002%') > > Still nothing, although issuing a similar select from phpMyAdmin gives > the result that I expect. > > phpMyAdmin SQL query: > SELECT * > FROM `searchtable` > WHERE `imageterms` LIKE CONVERT( _utf8 '%2000%' > USING latin1 ) > COLLATE latin1_swedish_ci > LIMIT 0 , 30 > >
Knowing very little about MySQL, those two queries seems to be not exactly the same. I'd try to use exactly the same query you get from SQLObject debug log, either pasting it in phpMyAdmin or in mysql command line client... -- Ksenia
