select count1 from docker_log where 1=1 and level = 1 and create_time = 1689552000 and end_time = 1689724800 and content like werewrdocker_serv ERROR 2023-07-19 164034370813 datawufandocker_servlogsda
这个错误是因为在SQL语句中使用了模糊匹配的LIKE操作符,但是未正确使用通配符"%werewr%"。正确的写法应该是将通配符放在引号内,如下所示:
SELECT COUNT(1) FROM docker_log WHERE 1=1 AND level = 1 AND create_time >= 1689552000 AND end_time <= 1689724800 AND content LIKE '%werewr%'
请注意,通配符%应该放在引号内,以确保正确的语法。
原文地址: https://www.cveoy.top/t/topic/ibSh 著作权归作者所有。请勿转载和采集!