模糊匹配中,精确匹配排在前面 select * from table1 where column1 like '%abcde%' order by LEN(column1) - LEN('abcde')