declare @t table(ID int,title varchar(20),workkey varchar(20),workkey2 varchar(20))
insert into @t select 1,'中国教育招商','教育|投资|招商','招商|教育'
insert into @t select 2,'abd ','i2 ',' '
insert into @t select 3,'cad ','i3 ',' '
insert into @t select 4,'bac ','i4 ',' 'select
title,id,workkey,workkey2
from
@t
where
workkey like '%教育%'
or
workkey2 like '%教育%'
or
title like '%教育%'
order by id desc /*
title id workkey workkey2
-------------------- ----------- -------------------- --------------------
中国教育招商 1 教育|投资|招商 招商|教育
*/
insert into @t select 1,'中国教育招商','教育|投资|招商','招商|教育'
insert into @t select 2,'abd ','i2 ',' '
insert into @t select 3,'cad ','i3 ',' '
insert into @t select 4,'bac ','i4 ',' 'select
title,id,workkey,workkey2
from
@t
where
workkey like '%教育%'
or
workkey2 like '%教育%'
or
title like '%教育%'
order by id desc /*
title id workkey workkey2
-------------------- ----------- -------------------- --------------------
中国教育招商 1 教育|投资|招商 招商|教育
*/
给我的回答,不过我的表是已经存在的了,是在ASP中调用该语句的。看能不能用sql语句取出唯一值!问题解决,马上结帐,谢谢~
是不是不要*呀
select title,id,workkey,workkey2 from A where workkey like '%教育%' or workkey2 like '%教育%' or title like '%教育%' order by id desc 或者‘
select * from A where workkey like '%教育%' or workkey2 like '%教育%' or title like '%教育%' order by id desc
select * from A where ID in(
select distinct ID from A where workkey like '%教育%' or workkey2 like
'%教育%' or title like '%教育%') order by id desc
--------------------------------------------------
select distinct * from A where workkey like '%教育%' or workkey2 like
'%教育%' or title like '%教育%' order by id desc