/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 vote133 views1 answer
Mysql récupérer le code création de vue
SQL
5 votes133 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote172 views2 answers
Insert data into multiple tables mysql
SQL
0 vote117 views1 answer
Lister les index d'une table oracle
SQL
4 votes136 views2 answers
Oracle set date format
SQL
0 vote141 views1 answer
Sql remove first character from string
SQL
0 vote152 views1 answer
Mysql into outfile with headers
SQL
0 vote122 views1 answer
Mysql workbench indent formatting
SQL
1 vote139 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote145 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL