Forum

Posted: **09 Jan 2015, 07:02**

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

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

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

Posted: **09 Jan 2015, 07:09**

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

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

Select rows where column contains character from list