MySQL Forums
Forum List  »  Full-Text Search

Re: GROUP BY in MATCH AGAINST
Posted by: gosmaster
Date: May 13, 2006 06:13PM

How nice to see my own question appearing while searching for an other sollution

SELECT * ,
MATCH ( content )
AGAINST ( '+mysql' IN BOOLEAN MODE) AS `bool_score`,
MATCH ( content )
AGAINST ( 'mysql' ) AS `score`
FROM `links`
WHERE MATCH ( content )
AGAINST ( 'mysql' )
GROUP BY `site_id`
HAVING
MATCH ( content )
AGAINST ( 'mysql' ) AND `bool_score` = '1'

DON'T "ORDER BY" AT ANY OF THE DB FIELDS OR "AS" FIELDS!

It will result in the returning of less relevant row's !





Edited 2 time(s). Last edit at 05/13/2006 06:17PM by gosmaster.

Options: ReplyQuote


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