mysql find non alphanumeric characters

Solutions on MaxInterview for mysql find non alphanumeric characters by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "mysql find non alphanumeric characters"
Ruben
01 Jan 2018
1/*find rows in mysql with non-alphanumeric chars*/
2SELECT * FROM user WHERE first_name REGEXP "[^A-Za-z0-9]+";
3
4/*find rows with non-alphanumeric or space chars*/
5SELECT * FROM user WHERE first_name REGEXP "[^A-Za-z0-9[:space:]]+";