/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 vote151 views1 answer
What is a Database?
SQL
0 vote167 views1 answer
How to change mysql port in xampp
SQL
0 vote176 views1 answer
How to get data from 2 database
SQL
1 vote161 views1 answer
Vagrant mysql downgrade version
SQL
3 votes163 views1 answer
Increment integer in table sql
SQL
0 vote180 views2 answers
Nested query
SQL
0 vote147 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote147 views1 answer
Grant privileges of databse to user
SQL
0 vote148 views1 answer
Mysql where don't have string
SQL
0 vote178 views1 answer
Sort by
SQL