mysql 查询

一条查询语句 模糊查询 完全匹配的优先 请教高手 本人菜鸟

这个估计比较麻烦，

看能不能这样

select * from a where a.name = 'aaa'
union all

select * from a where a.name like '%aaa%' and a.name != 'aaa'

没明白。。。

那就。。。。

select * from a where a.name = 'aaa'
union all

select * from a where a.name like 'aaa%' and a.name != 'aaa'
union all

select * from a where a.name like '%aaa' and a.name != 'aaa'