select * from table where field1 like '%keyword%' or field2 like '%keyword%' or field3 like '%keyword%'
create table tb (a varchar(20),b varchar(20),c varchar(20)) insert into tb select 'ab','bb','bc' insert into tb select 'aa','bb','dd' insert into tb select 'aa','bb','dc' declare @sql varchar(8000) select @sql=isnull(@sql+' or ','')+name+' like ''%c%''' from ( select name from syscolumns where id=object_id('tb'))tp set @sql='select * from tb where '+@sql exec(@sql)查有c字符的a b c ab bb bc aa bb dc
也就是要在TABLE中的多个字段进行查找,如何实现?
insert into tb select 'ab','bb','bc'
insert into tb select 'aa','bb','dd'
insert into tb select 'aa','bb','dc'
declare @sql varchar(8000)
select @sql=isnull(@sql+' or ','')+name+' like ''%c%''' from (
select name from syscolumns where id=object_id('tb'))tp
set @sql='select * from tb where '+@sql
exec(@sql)查有c字符的a b c
ab bb bc
aa bb dc