先贴sql
select now() from dual where 'mysql' like 'my_%';
竟然能查到数据
也就是说like不匹配下划线,下划线需要单独专一,修改如下:
select now() from dual where 'mysql' like 'my\_%';
ok了,下划线在sql中代表一个占位符
先贴sql
select now() from dual where 'mysql' like 'my_%';
竟然能查到数据
也就是说like不匹配下划线,下划线需要单独专一,修改如下:
select now() from dual where 'mysql' like 'my\_%';
ok了,下划线在sql中代表一个占位符