/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

1 vote199 views1 answer
List all triggers in SQL Server
SQL
7 votes196 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote184 views1 answer
Incorrect datetime value sql table error 1292
SQL
1 vote182 views1 answer
Error code 1055
SQL
1 vote193 views1 answer
Simple project for database
SQL
0 vote186 views2 answers
Insert into
SQL
1 vote195 views1 answer
Create another table from existing table sql oracle
SQL
-1 vote231 views2 answers
Full join sql
SQL
0 vote246 views1 answer
Datagrip exec
SQL
1 vote212 views1 answer
Sql random sampling per group
SQL