因为oracle不支持concat多个参数所以需要嵌套一层实现.
1.oracle
SELECT * FROM wb_service t where t.service_name like CONCAT('%','直播','%');
SELECT * FROM wb_service t where t.service_name like '%'||'直播'||'%';
2.mysql
SELECT * FROM wb_service t where t.service_name like CONCAT('%','直播','%');
通用
SELECT * FROM wb_service t where t.service_name like CONCAT(concat('%', '直播'), '%');