[thelist] text keys in MySQL

rudy r937 at interlog.com
Mon Jul 1 22:22:00 CDT 2002

>SELECT artid,faqid,title,content,
>match (title,content) against ('XYZ') as relevance
>FROM faqcont
>match (title,content) against ('XYZ')>0
>HAVING relevance>0
>ORDER BY relevance DESC

chris, i've never seen this type of sql before, but HAVING is usually
associated only with GROUP BY -- try pulling the HAVING clause out and see
what you get

i just looked up this syntax in the online mysql docs, and it looks pretty

apparently you can just say WHERE MATCH() AGAINST() without the greater
than zero test, because it will default to that

the docs also say the results are returned in relevance sequence


More information about the thelist mailing list