/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 vote591 views1 answer
How to lock table in mysql
SQL
3 votes186 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote172 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote185 views1 answer
Distance calculator from lat long sql query
SQL
0 vote183 views4 answers
Mysql replace regex
SQL
0 vote193 views1 answer
Neo4j command to run script file
SQL
0 vote155 views1 answer
How to create an SQL save method in ruby
SQL
0 vote220 views1 answer
Sql server sleep
SQL
0 vote200 views1 answer
Sql server insert inner join
SQL
1 vote286 views1 answer
Mysql monthname
SQL