[thelist] mysql - like

[Max Schwanekamp]

> From: Chris Price
> The next thing is searching on phrases so that if a search is made on
'this word' results are
> returned for 'this' or 'word'. Do you know any good resources for this
stuff.

Either use LIKE clauses or perhaps better, use fulltext searching, e.g.:

SELECT *, 
  MATCH(myCol) AGAINST ('this word') AS 'match_score'
FROM myTbl 
WHERE MATCH(myCol) AGAINST ('this word')
ORDER BY match_score DESC

(Though IIRC, 'this' is a stopword, i.e. MySQL ignores it in fulltext
searches, but I guess you just used it as a dummy value).

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

-- 
Max Schwanekamp
NeptuneWebworks.com