mysql find non alphanumeric characters

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

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:]]+";