Search Results order by more relevant
Is there a way to order the search results for the most relevant.
I have a search looking into more than one field on my table.
When the user search for something with more than 2 words it gives the right results but lets say I do a search for white carrara it will bring all the right results but the product with this exact name shows sometime on the bottom of the page sometimes in the middle.
I do not want to use the ORDER BY I know how to use this I want the most relevant result to show first.