/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 vote153 views1 answer
Postgresql array to rows
SQL
10 votes146 views3 answers
Insert into auto increment mysql
SQL
0 vote134 views1 answer
Test connection to sql server
SQL
2 votes157 views1 answer
Sql get the name of user pc
SQL
0 vote143 views1 answer
Low level operator in dbms
SQL
0 vote182 views1 answer
Sql multiple into
SQL
0 vote142 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote115 views1 answer
How to check oracle index table
SQL
2 votes146 views1 answer
Date_format for time sql
SQL
0 vote135 views1 answer
How to check if there is no database schema
SQL