I have this problem with this site where user can search by stock symbol or stock name
If it matchs exact with a symbol, results need to be displayed first then the remaining.
Table structure is like this :
pk | symbol | stockname
symbol = eta
stock name = energy transfer equity
You can use e.g.
select symbol, stockname from yourtable where ... order by (symbol = 'eta') desc
(symbol = 'eta') will have the value 1 when it matches, 0 if it doesn't match.