/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 vote95 views1 answer
Learn sqlite dart
SQL
-1 vote98 views8 answers
Create Trigger in phpMyAdmin
SQL
2 votes160 views5 answers
Install postgresql 10 centos 7
SQL
2 votes102 views1 answer
Get first n letter of department name in sql
SQL
1 vote108 views1 answer
Tsql find foreign key references
SQL
1 vote93 views1 answer
Nested if in mysql
SQL
0 vote102 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote95 views1 answer
How to access to mysql without root
SQL
1 vote100 views1 answer
Oracle start job
SQL
0 vote102 views1 answer
How to login to mysql in homestead
SQL