/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 vote159 views1 answer
Sql server select value large text
SQL
0 vote166 views1 answer
Sql select column name like from multiple tables
SQL
0 vote185 views1 answer
Using distinct and count together in sql
SQL
0 vote160 views1 answer
How to add boolean column in postgresql
SQL
1 vote198 views3 answers
Nth highest salary
SQL
3 votes178 views3 answers
Start postgresql ubuntu
SQL
1 vote149 views3 answers
Mariadb add foreign key
SQL
0 vote153 views1 answer
Oracle index hint
SQL
0 vote166 views1 answer
How to display value of variable in mysql
SQL
0 vote156 views1 answer
Sql select lowest value row
SQL