1,直接使用 会查不出来结果
select * from xxtable where user_no like '%05144%' limit 10;
2,下面语法可以正常查询出来结果
select * from xxtable where user_no like '%'+'05144'+'%' limit 10;
1,直接使用 会查不出来结果
select * from xxtable where user_no like '%05144%' limit 10;
2,下面语法可以正常查询出来结果
select * from xxtable where user_no like '%'+'05144'+'%' limit 10;