/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 vote137 views2 answers
Find a column in all tables mysql
SQL
2 votes179 views2 answers
How to check data type in sql server
SQL
0 vote156 views1 answer
Sql order by except one row
SQL
0 vote167 views1 answer
Sort by
SQL
0 vote147 views1 answer
Mysql local password denied
SQL
0 vote131 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote142 views1 answer
Sql server count all tables rows
SQL
0 vote185 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote151 views1 answer
Add sqlcmd to path linux
SQL
3 votes130 views1 answer
Oracle user quota unlimited
SQL