string matching

[lynx]

Hi,
I am trying to query a table and find if the field value can be found in a string, similar to the MATCH function except reversed. Example, the table field contains 'abc' and i want to see if it exists in the string "Now i know my abc's and 123's". Can anyone help me out, thanks.

[Oleg Butuzov]

REGEXP