MySQL Regex for Non English Characters

Question

I've looked all over Stack-Overflow and Google for a simple REGEX for MySQL that satisfies the following requirements:

• Finds all rows with a Non English Characters (ö, etc)
• Match any part of the column not just the first or last
• Allowed characters are anything but foreign characters (acceptable: _, A-Z, 0-9, # , " ' ( ) - @)

Any suggestions?

Answer 1

Try this

SELECT * FROM tableName WHERE NOT columnToCheck REGEXP '[A-Za-z0-9]';