/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 vote323 views1 answer
Oracle check table lock
SQL
1 vote317 views1 answer
Postgres cast as currency format
SQL
0 vote342 views1 answer
Sql ssrs
SQL
0 vote298 views1 answer
Find largest table in mysql database
SQL
7 votes310 views3 answers
Python and mysql connectivity
SQL
0 vote314 views1 answer
Alter rename command in mysql
SQL
2 votes321 views2 answers
Postgres trigger insert into another table
SQL
0 vote324 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote324 views1 answer
Oracle sql alter view add column
SQL
0 vote309 views1 answer
Mariadb errno 121
SQL