/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

23 votes276 views4 answers
How to uninstall postgresql in ubuntu
SQL
11 votes270 views2 answers
Docker create postgres db
SQL
1 vote270 views1 answer
Mysql show table character set
SQL
7 votes293 views3 answers
Convert ansi sql
SQL
0 vote272 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote276 views1 answer
Alter table myisam to innodb
SQL
18 votes287 views6 answers
Creating table in MySQL
SQL
0 vote272 views2 answers
How to type a blank discord messgae
SQL
1 vote233 views1 answer
Into sql
SQL
0 vote306 views1 answer
Transaction and commit trong sql server
SQL