/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 vote324 views1 answer
Find wordpress version in database
SQL
1 vote318 views1 answer
Alter table column size oracle
SQL
3 votes350 views1 answer
Oracle transaction commit rollback example
SQL
0 vote359 views1 answer
Python mysql show databases
SQL
6 votes372 views3 answers
Psql show columns of table
SQL
0 vote338 views1 answer
Sql alter table order by
SQL
0 vote370 views1 answer
How to add mysql to path on termin after installation
SQL
10 votes313 views1 answer
All_dependencies
SQL
1 vote335 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote337 views1 answer
Mariadb alter user host
SQL