Select rows where column contains character from list

[MarPlo]

I am trying to select all rows from a table where column contains a character from a list: Something like:

Code: Select all

SELECT * FROM table WHERE column (contains anything from {£,$,%,^,&,*,/} )

This is basically an illegal character check.
Can anyone help?
Thanks.

Try with REGEXP, and escape everything with backslash. Result: [\£\$\%\^\&\*\?].
SQL:

Code: Select all

SELECT * FROM table WHERE column REGEXP '[\£\$\%\^\&\*\?]'