鍍金池/ 問答/數(shù)據(jù)庫  HTML/ mysql 模糊查詢

mysql 模糊查詢

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

現(xiàn)在我想用devname或ip進行模糊查詢 該怎么寫 說明一下 我在sql字段中用了條件語句

回答
編輯回答
吃藕丑

select ip,devname,F.faultCode等
from (原來的查詢語句）
where ip like '%模糊條件%'
and devname like '%模糊條件%';

2018年4月17日 17:38