有个一个表table
A
YY123
YY121342
YY2354545
CC3535454
CC3454545
CCEFGYRTYRT现在我想按照条件A模糊查
下面数据集的数据
select * from table where A like 'YY%'
A
YY123
YY121342
YY2354545
CC3535454
CC3454545
CCEFGYRTYRT现在我想按照条件A模糊查
下面数据集的数据
select * from table where A like 'YY%'
select * from (select * from table where A like 'YY%') aa
where 条件
比如我输入YY1 就能得到
YY123
YY121342
我输入
CC34
就不会获得记录
select * from table where A like 'YY% ' and A like '%' + isnull(@y,A) + '%'