你舉出的例子也沒有typename=7的啊??是不是要這個?? Select * From TableName Where typeid=7
LZ的意思我还是没听太明白,要不把下面这个试试?不对再说.. Select * From TableName Where typeid=7
意思不太明白Select * From TableName Where typeid=7 ??
-----------是不是这样?Select * From TableName Where typeid like '%7%'
突发奇想,会不会楼主想表达.... Create table A(typename varchar(10),typeid varchar(10)) insert into A select '6','6,7' union all select '7','6,2' select * from A where charindex(typename,typeid)>0
应该是typename=b 如果是Select * From TableName Where typename=7就什么结果都没有如果是Select * From TableName Where typeid like '%7%' 则查出两条结果而实际结果只有第一条数据符合
Select * From TableName Where typename=7
Select * From TableName Where typeid=7
Select * From TableName Where typeid=7
??
Create table A(typename varchar(10),typeid varchar(10))
insert into A
select '6','6,7' union all
select '7','6,2' select * from A where charindex(typename,typeid)>0
如果是Select * From TableName Where typename=7就什么结果都没有如果是Select * From TableName Where typeid like '%7%' 则查出两条结果而实际结果只有第一条数据符合