Sorting in Fulltext search

[kpg]

MySQL returns an error when I add

AS rel WHERE rel > 0 ORDER BY rel DESC

to this query

"SELECT msgID, header, location, postingDate FROM posting_tb WHERE MATCH (emailBody) AGAINST ('$query'"

I would like to sort the result from the query by relevancy.

Any ideas? Thanks

[DR_LaRRY_PEpPeR]

is the error something such as "Unknown column 'rel' in WHERE clause?" that's because rel isn't a column. if you wanted to use rel's value in a WHERE-like clause, it would be HAVING:

AS rel HAVING rel > 0 ORDER BY rel DESC

however, a WHERE/HAVING shouldn't be needed. just use ORDER BY rel DESC and you should get the desired results.

[DR_LaRRY_PEpPeR]

i apologize! after i posted this last night, i realized that i told you wrong. i forgot how FULLTEXT search works. i think this is the correct query:

SELECT msgID, header, location, postingDate, MATCH (emailBody) AGAINST ('$query') AS rel FROM posting_tb WHERE MATCH (emailBody) AGAINST ('$query') ORDER BY rel DESC