Search code examples
mysqlregexsprinklr

Regex Expression For Mysql

I have data from twitter where I need to find if the word 'off' is present in the tweet but drop those rows where 'off' is present in any twitter handles. These mentions can be anywhere in the entire tweet string and cases like @offersforyou or @groffers are need to be dropped if 'off' is present anywhere in the mention, ie, anywhere in string between @ and immediate next blank space.

I am using mysql version 8.0.28 (ICU regex flavor).

Solution

  • "anywhere in string between @ and immediate next blank space" -->

     REGEXP "@\\w*off\\w*\\s"