不是很明你意思我理解的: select * from B表 where a in ('北京','南昌') and b in ('北京','南昌')
select * from B where ( charindex(',北京,',','+a+',')>0 or charindex(',南昌,',','+a+',')>0 ) and ( charindex(',北京,',','+b+',')>0 or charindex(',南昌,',','+b+',')>0 )
select * from B表 where (a like '%北京%' or a like '%南昌%') and (b like '%北京%' or b like '%南昌%')
select * from cominfo where ( charindex(',"&mdd2&",',','+chufadi+',')>0 or charindex(',"&mdd&",',','+chufadi+',')>0 ) and ( charindex(',"&mdd2&",',','+mudidi+',')>0 or charindex(',"&mdd&",',','+mudidi+',')>0 ) order by id desc那里错了?运行不了
a字段包含北京或南昌且B字段包含北京或南昌SELECT * FROM B WHERE (a like '%北京%' OR a like '%南昌%') AND (b like '%北京%' OR b = '%南昌%')
select * from cominfo where ( charindex(','"&mdd2&"',',','+chufadi+',')>0 or charindex(','"&mdd&"',',','+chufadi+',')>0 ) and ( charindex(','"&mdd2&"',',','+mudidi+',')>0 or charindex(','"&mdd&"',',','+mudidi+',')>0 ) order by id desc
不是很明你意思我理解的:
select * from B表 where a in ('北京','南昌') and b in ('北京','南昌')
and ( charindex(',北京,',','+b+',')>0 or charindex(',南昌,',','+b+',')>0 )
and ( charindex(',"&mdd2&",',','+mudidi+',')>0 or charindex(',"&mdd&",',','+mudidi+',')>0 ) order by id desc那里错了?运行不了
WHERE (a like '%北京%' OR a like '%南昌%') AND (b like '%北京%' OR b = '%南昌%')
and ( charindex(','"&mdd2&"',',','+mudidi+',')>0 or charindex(','"&mdd&"',',','+mudidi+',')>0 ) order by id desc