match ... against on more field: give more importance to first field?
I do a query like this
SELECT * FROM . WHERE MATCH(title,text) AGAINST ('word1') LIMIT 100
now of coure title is more important than text. Are there a way to tell mysql it should give more revelance if word1 is found in t开发者_开发问答itle than text?
Thanks
this should do it but its seems a little clunky
SELECT * FROM 
(SELECT * FROM  WHERE 
MATCH(title) AGAINST ('word1') 
UNION
SELECT * FROM  WHERE 
MATCH(text) AGAINST ('word1') 
) t
LIMIT 100
 
         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论