/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 vote302 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote289 views1 answer
Alter boolean column postgresql
SQL
0 vote278 views1 answer
Mysql enter ubuntu
SQL
-1 vote270 views1 answer
Su: Authentication failure mysql
SQL
0 vote307 views1 answer
Yesql
SQL
2 votes218 views1 answer
Sql group by different columns
SQL
0 vote266 views1 answer
Get number of tables in database sql
SQL
3 votes309 views5 answers
No module named 'MySQLdb'
SQL
0 vote280 views1 answer
Sql query to find duplicate email address
SQL
0 vote314 views1 answer
Look at running processes redshift
SQL