SQL in RULES

EMQX
1

Hello.

Please how i can do find a substring in the “where” for the condition. For example I have:

A payload = ’ this sample of the string"

I ned:

SELECT * FROM ‘t/#’ WHERE ‘sample’ in payload

Exist any sentence for a substring in one string…?

Thanks
Fausto.

2

Hello,

Please, Can this be done…?

Thanks…
Fausto

3

You can use the find() function to find the beginning of the substring and return the remainder:

Examples:

find('ab..cd..ef', '.', leading) = '..cd..ef'
find('ab..cd..ef', '..', trailing) = '..ef'
find('ab..cd..ef', 'x', leading) = ''
find('ab..cd..ef', 'x', trailing) = ''