drop table message
create table message
(message_id int identity(1,1),
message_title varchar(50),
update_time datetime)
insert message(message_title,update_time)
select '南山科技园厂房','2006-8-1' union all
select '南山写字楼','2006-8-2' union all
select '科技园写字楼','2006-8-1' union all
select '南山区科技园写字楼招租','2006-8-3' union all
select '南区科技写字楼招租','2006-8-1'
--select * from message
select * from message
order by
case
when (charindex('南山',message_title,1)>1 and charindex('科技园',message_title,1)>1) then 2
when (charindex('南山',message_title,1)>1 or charindex('科技园',message_title,1)>1) then 1
else 0
end desc,update_time desc