select * from tb_staff a where a.istaffid !='0'
and a.istaffid not like '\_%' escape '\';
Oracle在使用like中匹配下划线的方法
最新推荐文章于 2024-05-10 14:58:12 发布
select * from tb_staff a where a.istaffid !='0'
and a.istaffid not like '\_%' escape '\';