1、_表示占位符,只占一位;%表示占位符,占多个位置;
2、select * from wjj_0104 a where a.full_name like '$_%' escape '$';其中$为被定义的转义符,_为被转义的符号;
select * from wjj_0104 a where a.full_name like '$_%' escape '$';
select * from wjj_0104 a where a.full_name like '$_' escape '$';
select * from wjj_0104 a where a.full_name like '$_$_' escape '$';
select * from wjj_0104 a where a.full_name like '$__' escape '$';
故目前发现:escape只可转义_ 和 %