/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

3 votes239 views1 answer
Sql several or
SQL
0 vote240 views1 answer
How to remove default in mysql
SQL
0 vote258 views2 answers
Nested query
SQL
10 votes237 views2 answers
Mysql select timestamp group by day
SQL
0 vote259 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote243 views1 answer
Mysql group by derived column
SQL
-1 vote289 views1 answer
How to Activate the database
SQL
0 vote273 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote252 views2 answers
Sql searching via key word
SQL
3 votes233 views1 answer
Get all elements sql
SQL