/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

4 votes294 views3 answers
Postgres set default value
SQL
0 vote307 views1 answer
Sql count * vs count 1
SQL
1 vote296 views1 answer
Python clean sql string
SQL
1 vote276 views1 answer
Clear screen command in psql
SQL
0 vote291 views1 answer
Limiting query result using where in sql
SQL
1 vote283 views1 answer
Base nosql
SQL
-1 vote291 views1 answer
Ssql to lowercqse
SQL
1 vote281 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote289 views1 answer
Show table status command in mysql
SQL
13 votes321 views5 answers
Alter table query sql server change column
SQL