因 select id from order where id like ‘%_%’,会把所有结果查询出来,所以更新为: select id from order where id like ‘%[_]%’ ,加入中括号