/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 vote409 views4 answers
Full outer join in sql
SQL
0 vote381 views1 answer
Sql gather statistics to increase performance
SQL
3 votes378 views1 answer
APEX elapsed time
SQL
0 vote352 views1 answer
Criteria builder select subset of column
SQL
8 votes315 views1 answer
Similarities between ddl and dml
SQL
-1 vote373 views1 answer
Round up and down sql
SQL
0 vote341 views1 answer
Sql remove last x char
SQL
4 votes356 views2 answers
Oracle sql group by date year
SQL
0 vote359 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
2 votes342 views2 answers
Exec procedure pl sql
SQL