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.
Hello,
Please, Can this be done…?
Thanks…
Fausto
liuxy
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) = ''