MySQL Forums
Forum List  »  Full-Text Search

GROUP BY in MATCH AGAINST
Posted by: gosmaster
Date: April 11, 2006 02:10AM

All right, i can't seem to figure out how i can 'group' on a certain id (site_id), and show the best scores.

This isn't valid Query; I should swap the 'order by' and the 'group by', but then the remaning records, are not the records with the best score...

SELECT * ,

MATCH (content)

AGAINST ('mysql') AS score

FROM links

WHERE MATCH (content)

AGAINST ('mysql')

ORDER BY `score` DESC

GROUP BY `site_id`



Edited 1 time(s). Last edit at 04/11/2006 08:52AM by gosmaster.

Options: ReplyQuote


Subject
Views
Written By
Posted
GROUP BY in MATCH AGAINST
6111
April 11, 2006 02:10AM
3135
April 11, 2006 05:19AM
4755
May 13, 2006 06:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.