/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 vote197 views1 answer
Oracle sql date summer time
SQL
0 vote198 views1 answer
How to list function in psql
SQL
0 vote218 views1 answer
Mysql export data with a where clause
SQL
0 vote181 views1 answer
Mysql use password error
SQL
2 votes272 views2 answers
Postgres timestamp to datetime
SQL
0 vote194 views1 answer
Sql server select value large text
SQL
0 vote188 views1 answer
Sql count null as 0
SQL
11 votes296 views5 answers
Update table from another table mysql
SQL
5 votes198 views3 answers
Postgres show databases
SQL
5 votes227 views3 answers
Select tables from mysql database
SQL