/SQL/Mysql find non alphanumeric characters

Mysql find non alphanumeric characters

/*find rows in mysql with non-alphanumeric chars*/
SELECT * FROM user WHERE first_name REGEXP "[^A-Za-z0-9]+";

/*find rows with non-alphanumeric or space chars*/
SELECT * FROM user WHERE first_name REGEXP "[^A-Za-z0-9[:space:]]+";

Similar codes

0 vote112 views1 answer
How to find columns with null values in sql
SQL
0 vote136 views1 answer
Sql order by number not ordered
SQL
0 vote118 views1 answer
SQL server datetime compare
SQL
0 vote136 views1 answer
Replace sqlalchemy
SQL
5 votes116 views1 answer
Commentaire table oracle
SQL
0 vote119 views1 answer
No suitable driver found for sqlite
SQL
0 vote105 views1 answer
Groupby sort sql hive
SQL
0 vote107 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote121 views1 answer
Sql server pivot rows to columns
SQL
0 vote122 views1 answer
Make parameters nullable in sql server
SQL