这个SQL语句如何写，

[zxd1207]

ACCESS 数据表中有一个字段为TTO ：
表：b1
样例：
TTO
1，2，3
2，3，4
1，2，5
我想选出TTO 中包含1的行，请问如何写

[cenxaoi]

select * from bl where tto like '%1%'

[chenghy]

select * from b1 where tto like '%1%'

[amtyuranus]

select * from b1 where tto='1'

[lbd8848]

select * from b1 where tto like '1%'

[奇遇]

select * from b1 where tto='*1*'

[hahasw]

Select * From bl Where TTO Like '%,1,%'

[hycapril]

select * from b1 where tto='*1*'

[borisnew]

select * from b1 where tto like "*1"
用“不是‘

[xiaoweiwei1976]

dim i as integer

i = 1



select * from bl where tto like '% " & i & "%'


最正确的答案，能得几分？

[ys497]

select * from b1 where tto='*1*'

最简洁！

[cenxaoi]

select * from b1 where tto like '*1*'
这样子的话连 10,2,3也会出现啊
select * from b1 where tto like '1,*'
union
select * from b1 where tto like '*,1'
union
select * from b1 where tto like '*,1,*'

兼顾 1,2,3 2,1,3 3,2,1 三种情况。

[changechange]

cenxaoi(毅)
你这样也不行，如果是 1,1,1哪？
就要选3遍了！

[cenxaoi]

不错 改了又改

select distinct * from (
select * from b1 where tto like '1,*'
union
select * from b1 where tto like '*,1'
union
select * from b1 where tto like '*,1,*'
)