Sean: we already use LIKE, but we do it like `FIELD LIKE "%SEARCHTERM%"', which ends up finding exactly the phrase SEARCHTERM. It isn't hard though, you just split on spaces and add a LIKE '%WORD' for every word in the phrase. Owen's already got it covered though.
Sean: we already use LIKE, but we do it like `FIELD LIKE "%SEARCHTERM%"', which ends up finding exactly the phrase SEARCHTERM. It isn't hard though, you just split on spaces and add a LIKE '%WORD' for every word in the phrase. Owen's already got it covered though.