/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 votes189 views2 answers
Oracle source code
SQL
0 vote197 views1 answer
Data directory postgresql
SQL
-1 vote227 views1 answer
How to Activate the database
SQL
0 vote193 views1 answer
Linked server delete openquery
SQL
15 votes187 views2 answers
Select Options
SQL
0 vote180 views3 answers
Postgresql grant alter table to user
SQL
1 vote188 views1 answer
Set mysql mode global query
SQL
0 vote225 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
9 votes341 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote189 views2 answers
Sql query inner join 3 tables
SQL