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.
Subject
Views
Written By
Posted
GROUP BY in MATCH AGAINST
6155
April 11, 2006 02:10AM
3154
April 11, 2006 05:19AM
4773
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.