sqlserver模糊查询高难度
1可以实现
select * from dt_DataDetail where SN in('AC031616L','AC031679L')
2实现不了
select * from dt_StorageIMEI where PSE like ('%2Y0316124ADA%','%2Y0316125ADA%')
求2的实现方法 sqlserver
[解决办法]
select * from dt_StorageIMEI
where PSE like '%2Y0316124ADA%' or PSE like '%2Y0316125ADA%'
[解决办法]
select * from dt_StorageIMEI where PSE like '%2Y031612[45]ADA%'