lf-edge
Regex In SQL
Is it possible to use regex in SQL statements? if yes... please give an example of it
There are functions like regexp_matches, check https://ekuiper.org/docs/en/latest/sqls/built-in_functions.html#string-functions
@ngjaying . Can you please confirm the syntax is correct here ? does the case insensitive syntax is correct? { "id": "RegexCheck", "sql": "SELECT CASE WHEN json_path_exists(pipelineList,"$..[? (@.pipelineId =~ \"/abc/i\")]") AND correlationId ="abccorr123rrt" THEN "Success" ELSE "failure#rule conditions not met" END as status_msg,correlationId FROM controlroom", "actions": [ { "log": {} }, { "mqtt": { "server": "tcp://localhost:60020", "topic": "resulttest" } } ] }