不好处理的sql语句>>>>

SELECT * FROM tableName where charindex( 
(select substring(mobNumber,1,3) from tableName),'134,135,136,137,138,139,150,151,152,157,158,159' 
)>0 

小弟想实现从数据库中查询属于中国移动的电话号码。
现在报：

select substring(mobNumber,1,3) from tableName 的结果集不止一行.... 

select * from tableName t where substr(t.phoneNo,1,3) in ('134,135,136,137,138,139,150,151,152,157,158,159' )

SELECT * FROM tableName where substring(mobNumber, 1, 3)
in ('134','135','136','137','138','139','150','151','152','157','158','159');