假设表“ims_gkwh_dictdata”有记录的字段data_value的值为“不合规字符”,验证提交的字符含有“不合规字符”的sql语句如下:
SELECT * FROM ims_gkwh_dictdata WHERE INSTR('不合规字符111',data_value)>0
假设表“ims_gkwh_dictdata”有记录的字段data_value的值为“不合规字符”,验证提交的字符含有“不合规字符”的sql语句如下:
SELECT * FROM ims_gkwh_dictdata WHERE INSTR('不合规字符111',data_value)>0