/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 vote194 views1 answer
Show indices in mysql table
SQL
0 vote176 views1 answer
Update top 100 sql
SQL
0 vote223 views1 answer
Mysql 3 months ago
SQL
0 vote170 views1 answer
Postgres create database if not exists
SQL
1 vote183 views1 answer
Set mysql mode global query
SQL
7 votes172 views1 answer
Sql server convert string to date
SQL
1 vote187 views1 answer
Convert varchar to int in sqlite
SQL
0 vote197 views1 answer
Declaring variables in pl sql
SQL
1 vote192 views1 answer
Mysql dump specific tables
SQL
0 vote178 views1 answer
Sql make sure every user is unqiuew
SQL