/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

2 votes342 views1 answer
Oracle index size
SQL
2 votes371 views2 answers
How to check database username and password in postgresql
SQL
4 votes337 views2 answers
Xampp mysql database server is not starting mac m1
SQL
0 vote296 views1 answer
Sql table to store status
SQL
6 votes356 views4 answers
Delete table sqlite
SQL
0 vote349 views4 answers
Change schema in sql server
SQL
0 vote381 views1 answer
Postgresql inheritance
SQL
0 vote361 views1 answer
Postgres row expiration
SQL
0 vote327 views1 answer
Postgresql subquery
SQL
0 vote397 views1 answer
Move table to a different schema
SQL