mysql 模糊查询

Question

sql语句：

select case ISNULL(case ISNULL(CA.ip) when true then C.crsIp else CA.ip  end) when true then '该设备已被删除' else (case ISNULL(CA.ip) when true then C.crsIp else CA.ip  end) end as ip,case ISNULL(case ISNULL(CA.cameraName) when true then C.crsName else CA.cameraName end) when true then '该设备已被删除' else (case ISNULL(CA.cameraName) when true then C.crsName else CA.cameraName end) end as devname,F.faultCode,F.memo,F.isLock,F.startTime,F.endTime from fault_list as F left join crossing as C on F.faultCode=C.crsCode left join camera as CA on F.faultCode=CA.cameraCode where F.isLock=1

现在我想用devname或ip进行模糊查询 该怎么写 说明一下 我在sql字段中用了条件语句

Answer 1

select ip,devname,F.faultCode等
from (原来的查询语句）
where ip like '%模糊条件%'
and devname like '%模糊条件%';