--我的关键字[策典设计]
sql="select * from yp where 1=1 and title like '%策典设计%' or info like '%策典设计%' or title like '%策典%' or title like '%典设%' or title like '%设计%' or info like '%策典%' or info like '%典设%' or info like '%设计%' order by id asc"我想让[策典设计]在标题中最先出现先罗列出来,其次在内容中有的再显示出来,请问大家该如何做?
select * from yp where 1=1 and title like '%策典设计%' or info like '%策典设计%'
or title like '%策典%' or title like '%典设%' or title like '%设计%' or info like '%策典%' or info like '%典设%' or info like '%设计%'
order by CASE WHEN title like '%策典设计%' or info like '%策典设计%' THEN 1 ELSE 2 END
--try
sql="select * from yp where 1=1 and title like '%策典设计%' or info like '%策典设计%' or title like '%策典%' or title like '%典设%' or title like '%设计%' or info like '%策典%' or info like '%典设%' or info like '%设计%' order by id asc,order by case when title like '%策典设计%' then 1 else 0 end desc"
or title like '%策典%' or title like '%典设%' or title like '%设计%' or info like '%策典%' or info like '%典设%' or info like '%设计%'
order by CASE WHEN title like '%策典设计%' or info like '%策典设计%' THEN 1 ELSE 2 END
or title like '%策典%' or title like '%典设%' or title like '%设计%' or info like '%策典%' or info like '%典设%' or info like '%设计%'
order by CASE WHEN title like '%策典设计%' or info like '%策典设计%' THEN 1 ELSE 2 END