/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 vote336 views1 answer
How to stop all connections to a psql 12 database?
SQL
-2 votes325 views1 answer
Mysql not empty
SQL
0 vote353 views1 answer
Print boolean in plsql
SQL
0 vote332 views1 answer
Export partttion and import in oracle
SQL
0 vote347 views1 answer
Call scalar valued function sql
SQL
0 vote311 views1 answer
Dump only schema
SQL
1 vote384 views1 answer
Drop colum oracle 18c
SQL
-1 vote354 views1 answer
Round up and down sql
SQL
0 vote346 views1 answer
Postgresql in vs any performance
SQL
0 vote357 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL