求SQL语句一条！！！各位给点意见

[oldwatch]

数据库如下
id company area_id
1 xx 111,2,3,4
2 yy 10,5,6,7
3 zz 21,7,4,8
4 aa 13,46,666
5 ff 1,6334,634,4

当a_id=4的时候，从area_id搜索出有4的company
如果a_id=4，那么company=xx、zz、ff

[jay_lishijie]

select area_id where area_id like %a_id%
select company where area_id like a_id

[sky0120]

select company from yourtb where area_id like '%"&a_id&"%'

[subasan]

select * from mytable where [id] in (select [id] from mytable where [id]='4' and [id] in area_id)

[oldwatch]

不行啊，TOsubasan(暴走的拖鞋)id跟area_id是完全没有关系的，可以这样说：
数据库company
company area_id
xx 111,2,3,4
`yy 10,5,6,7
`zz 21,7,4,8
`aa 13,46,666
`ff 1,6334,634,4
当a_id=4的时候，从area_id搜索出有4的company
如果a_id=4，那么company=xx、zz、ff

[oldwatch]

select company from yourtb where area_id like '%,"&a_id&"%'or area_id like '%,"&a_id&",%' or area_id like '%"&a_id&",%'

奇怪
为什么这样都不行，问题出在哪里？

[Radar2006]

用的是什么数据库？
access中通配符用"*",
select company from yourtb where area_id like '*" & a_id & "*'
sqlsvr中用"%",
select company from yourtb where area_id like '%" & a_id & "%'

[oldwatch]

access数据库

[oldwatch]

问题还没有解决，UP

[oldwatch]

问题解决！