/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 vote200 views1 answer
Mysql add root password
SQL
0 vote196 views1 answer
Login phpmyadmin without password
SQL
0 vote198 views1 answer
The local psql command could not be located
SQL
0 vote191 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote221 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote191 views1 answer
Wordpress sql find and replace
SQL
1 vote205 views1 answer
Sqlite create index
SQL
16 votes222 views3 answers
Jwt secret key generator laravel
SQL
11 votes224 views5 answers
Laravel db facade
SQL
5 votes207 views1 answer
Oracle list days between two dates
SQL