DISTINCT i full text
Jeg er ved at lave et site med full text søgning, men vil gerne have en DISTINCT på den .. er det muligt ?min sql er som det her ;
SELECT MATCH (test1,test2) AGAINST ('+hvad' IN BOOLEAN MODE) as score, test1, test2, Base, test3 FROM w WHERE MATCH (test1,test2) AGAINST ('+hvad' IN BOOLEAN MODE) order by score desc LIMIT 0,20
Men synes ikke virker
SELECT DISTINCT (Base), MATCH (test1,test2) AGAINST ('+hvad' IN BOOLEAN MODE) as score, test1, test2, test3 FROM w WHERE MATCH (test1,test2) AGAINST ('+hvad' IN BOOLEAN MODE) order by score desc LIMIT 0,20
