/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 vote158 views1 answer
Mysql grant access to one database
SQL
16 votes135 views5 answers
Select last row in sql
SQL
1 vote117 views1 answer
Tsql get beginning of year
SQL
0 vote131 views1 answer
Python sqlalchemy connection show server
SQL
1 vote306 views1 answer
Foreign key in oracle sql developer
SQL
0 vote118 views1 answer
Mysql query single row
SQL
0 vote121 views1 answer
Select * from mysql.proc
SQL
34 votes140 views6 answers
Install mysql client ubuntu
SQL
15 votes121 views6 answers
Psql
SQL
0 vote131 views1 answer
Dynamic where clause in sql server stored procedure
SQL