/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 vote230 views1 answer
Except in sql
SQL
0 vote244 views1 answer
Postgresql delete limit
SQL
0 vote223 views1 answer
Sql select all records from all tables where not empty
SQL
7 votes254 views4 answers
Index in mysql
SQL
0 vote221 views1 answer
Sub blocks in sql
SQL
0 vote254 views1 answer
Fetching data from mysqldb
SQL
2 votes241 views1 answer
Revokeprivileges mysql
SQL
0 vote224 views1 answer
Oracle step procedure
SQL
2 votes244 views2 answers
Mysql count rows returned
SQL
0 vote227 views1 answer
Start and stop mysql
SQL