如果我有一张桌子
column
---------------------
his name is yyy
What is your name
my name is xxx
如果在使用“ like”和“ OR”功能时必须搜索包含“ What”和“ Name”的单词,我将得到结果,但没有顺序。如何使包含两个单词的结果排在最前面,然后再按任意顺序排列
您可以使用联合:
select column from table where column like ('%What%') and column like ('%name%')
union
select column from table where (column like ('%What%') or column like ('%name%')) and column not in (select column from table where column like ('%What%') and column like ('%name%'))
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句