/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

11 votes183 views4 answers
MYSQL LOGIN
SQL
0 vote160 views1 answer
Sql select maximum column with other columns returned
SQL
1 vote176 views1 answer
Convert to hexadecimal sql
SQL
7 votes169 views1 answer
Oracle reset sequence
SQL
37 votes253 views6 answers
Mysql update
SQL
0 vote186 views1 answer
What is between keyword used for
SQL
0 vote195 views2 answers
How to know the character set of an oracle databes
SQL
11 votes193 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
2 votes205 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote186 views1 answer
Oracle list datafiles
SQL