[thelist] mysql - like

[Chris Price]

Thanks Max

That's exactly what I was looking for.

You're right, 'this' was just a dummy value.

Its not a good word to use when asking questions because as well as 
being a stop word it has specific meaning other contexts.

--
Chris Price

On Thursday, August 24, 2006, at 09:49  am, Max Schwanekamp wrote:

> 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