/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 vote221 views2 answers
How to drop a unique constraint in sql
SQL
0 vote238 views1 answer
Get number of rows in every table mysql
SQL
1 vote245 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote205 views2 answers
Sql update from two different database
SQL
1 vote204 views2 answers
Procedure pl/sql
SQL
1 vote218 views1 answer
Oracle start job
SQL
0 vote222 views1 answer
Default column value in sql same as other column
SQL
13 votes248 views3 answers
Insert mysql ifile nto database
SQL
-1 vote197 views2 answers
Datetime sql server week
SQL
1 vote228 views1 answer
Postgresql datetrunc too slow
SQL