/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 vote119 views1 answer
Mysql repair a table
SQL
0 vote130 views1 answer
Less than date query sqlachemy
SQL
12 votes136 views6 answers
Between in sql
SQL
4 votes83 views1 answer
And or sql order of operations
SQL
0 vote124 views1 answer
Like and not like together in sql
SQL
1 vote128 views1 answer
Mysql count multiple columns in one query
SQL
8 votes142 views1 answer
Oracle search stored procedures for text
SQL
0 vote134 views1 answer
Mysql local password denied
SQL
1 vote128 views3 answers
Sql select only time from datetime
SQL
0 vote129 views1 answer
Get last three characters in mysql column
SQL