/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

1 vote198 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
8 votes181 views2 answers
Mysql query dates between two dates
SQL
10 votes191 views4 answers
SELECT FROM WHERE
SQL
0 vote261 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote182 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote182 views1 answer
Enable full text search mysql
SQL
0 vote201 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
31 votes202 views3 answers
Sql count
SQL
0 vote220 views1 answer
Oracle to_number
SQL
5 votes207 views1 answer
AND OR NOT operators sql
SQL