Is it possible to perform a search query ordered by relevance? What I wanto to do can be completed by 3 different queries which is inefficient for my autocomplete search case. The order I want my query to result is :
name = textBeingEntered
name LIKE textBeingEntered+" “+”%"
name LIKE “%”+textBeingEntered+"%"
I guess there is not any solution to this but is there anything you would recommend for my case? Thanks