/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 vote300 views1 answer
Back up stored procedures mysql
SQL
0 vote355 views1 answer
Delete from table where length sql
SQL
2 votes328 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote367 views3 answers
Constraint sql
SQL
10 votes326 views6 answers
Sql between
SQL
0 vote301 views1 answer
Select only one row sql
SQL
21 votes312 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote311 views1 answer
Mysql docker image arjun
SQL
23 votes333 views3 answers
Sql where contains part of string
SQL
0 vote307 views1 answer
Display first three characters sql
SQL