/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

2 votes104 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
4 votes116 views2 answers
Float postgres
SQL
0 vote110 views1 answer
Sql counter column
SQL
0 vote94 views1 answer
Start stop mysql linux
SQL
12 votes100 views3 answers
Install sqlite driver ubuntu
SQL
0 vote98 views1 answer
Postgresql function ROUND
SQL
0 vote108 views2 answers
How to take recent row without limit in mysql
SQL
0 vote100 views1 answer
How to fetch unique records from two tables
SQL
0 vote98 views1 answer
Android sqlite get rows count
SQL
0 vote119 views1 answer
Excel vba import data to sql server
SQL