/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 vote100 views2 answers
Into sql
SQL
3 votes130 views2 answers
Mysql import gz
SQL
103 votes192 views2 answers
Sql server LIKE '%%'
SQL
1 vote108 views1 answer
Pv mysql import
SQL
1 vote125 views2 answers
Mysql limit offset
SQL
0 vote71 views1 answer
Query for maximum salary
SQL
1 vote76 views1 answer
Sql convert month name to number
SQL
0 vote103 views1 answer
Vbscript create ADODB.Connection
SQL
1 vote256 views1 answer
Postgres upgrade to superuser
SQL
6 votes139 views2 answers
Mysql timestamp to date
SQL