/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

0 vote383 views1 answer
Finding leap year in sql
SQL
8 votes340 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote323 views2 answers
Mysql regexp match word
SQL
13 votes335 views6 answers
Mysql remove duplicates
SQL
13 votes349 views3 answers
Insert mysql ifile nto database
SQL
0 vote343 views1 answer
R write csv without index
SQL
0 vote363 views1 answer
Postgres list tables and row counts
SQL
1 vote309 views1 answer
Truncate left characters mysql
SQL
2 votes320 views1 answer
Plsql block
SQL
0 vote303 views1 answer
Sql compound operators
SQL