[thelist] mysql - like
Chris Price
chris.price at choctaw.co.uk
Thu Aug 24 04:17:04 CDT 2006
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
More information about the thelist
mailing list