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