How to support where like sql

[piterus-xu]

sql like this:
select * from report where msg like %dev/query/res%

how to support it!

[bramp]

That should be supported. Do you get a error message? Maybe you are missing quotes from your example?

select * from report where msg like "%dev/query/res%"

[piterus-xu]

curl request:
curl -XPOST -d '{"startEpoch":"now-8h","endEpoch":"now","searchText":"SELECT msg FROM logstash-broker-siglens-2025.04.21 where msg like "%dev/query/res%","indexName":"logstash-broker-siglens-2025.04.21","queryLanguage":"SQL"}' "http://172.18.44.14:5122/api/search"

error log below:

[piterus-xu]

curl -XPOST -d '{"startEpoch":"now-8h","endEpoch":"now","searchText":"SELECT msg FROM logstash-broker-siglens-2025.04.21 where msg like "%dev/query/res%"","indexName":"logstash-broker-siglens-2025.04.21","queryLanguage":"SQL"}' "http://172.18.44.14:5122/api/search", 改成这样同样报错, {"error":"Error processing search request: qid=185, ParseAndExecutePipeRequest: Error parsing query:SELECT msg FROM logstash-broker-siglens-2025.04.21 where msg like "%dev/query/res%", err: syntax error at position 35"}