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
