关于like 查询条件如何实现

SELECT * FROM stb_pcdn_platform  WHERE (LOWER(sn) LIKE LOWER('%CD%') OR LOWER(mac) LIKE LOWER('%CD%')) AND sid=201020;

这种sql 用cnd如何拼接

Cnd.where(Cnd.exps("LOWER(sn)", "LIKE", "LOWER('%CD%')")
.or("LOWER(mac)", "LIKE", "LOWER('%CD%')"))
.and("sid", "=", 201020);

或者自定义sql

请先登陆