[thelist] text keys in MySQL

[rudy]

>SELECT artid,faqid,title,content,
>match (title,content) against ('XYZ') as relevance
>FROM faqcont
>WHERE
>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
spiffy

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

rudy