/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

3 votes138 views3 answers
Raw select laravel
SQL
3 votes116 views1 answer
Postgres update column with value from another table
SQL
0 vote89 views1 answer
Get last run query sql server
SQL
0 vote137 views1 answer
Mssql disable foreign key constraint
SQL
6 votes135 views1 answer
Identify primary key in oracle table
SQL
0 vote142 views1 answer
Oracle show grants on table
SQL
0 vote165 views1 answer
Create table as select sql server error
SQL
5 votes162 views4 answers
Sql check
SQL
0 vote129 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
18 votes123 views3 answers
Mysql add column with default value
SQL