/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 vote216 views1 answer
Mysql select field if condition
SQL
42 votes263 views6 answers
Rename table sql server
SQL
0 vote224 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote221 views2 answers
Create-toys-table-with-toy_name-column
SQL
1 vote214 views1 answer
Get rows affected mysql python
SQL
0 vote249 views1 answer
Psql check if sql script is valid
SQL
0 vote232 views1 answer
Postgresql replace html tags from string
SQL
0 vote216 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
20 votes235 views3 answers
How to open postgresql in mac
SQL
0 vote178 views1 answer
Mysql find foreign key references
SQL