精准查询一个字段和模糊搜索另一字段语句
SELECT * from snmpnorthpoint where id='1271106029' and devname LIKE '%E列%';最近访问时间：2026-08-31 14:12:12
SELECT * from snmpnorthpoint where id='1271106029' and devname LIKE '%E列%';