mysql search top match should come first -
In the match - getting the right result, there is no problem, but what I want is the combination combination " Computer Graphics "is the result of" Computer + Graphics "for me as results of" Computer "and getting" Computer Graphics "results and" Graphics "results and etc.
> Here I want the first "computer graphics" result, then the second single word match result. How can I bring them before please help me any one
You must order according to relevance : Search for the same query where you use in WHERE, the call is issued from that area and then the order by that area.
Against the SELECT MATCH ('...') table ('...') as a relevance to the table WHERE MATCH ('...') ...) in the 'Boolean mode' relevance Order by DESC
Comments
Post a Comment