Re: GROUP BY in MATCH AGAINST

[gosmaster]

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.