/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

0 vote260 views1 answer
Unique index in mysql
SQL
0 vote260 views1 answer
Find all tables where column name exists oracle
SQL
0 vote257 views1 answer
Call function sql oracle
SQL
2 votes210 views1 answer
Oracle current date without time
SQL
0 vote252 views1 answer
Mysql show foreign keys column
SQL
0 vote273 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote253 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote214 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
2 votes263 views1 answer
Oracle sql concatenate results into string
SQL
1 vote269 views2 answers
Install mysqldump ubuntu
SQL