/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 vote161 views1 answer
Sql query row number group by
SQL
1 vote200 views1 answer
Mysql stop password policy
SQL
0 vote128 views1 answer
Get sum sqlite android
SQL
0 vote133 views1 answer
Postgres select except
SQL
0 vote142 views1 answer
Mssql check if date is greater than today
SQL
1 vote134 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote151 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
25 votes146 views3 answers
Mysql command show tables
SQL
5 votes140 views1 answer
Oracle nls session
SQL
0 vote147 views2 answers
Null value in column violates not-null constraint
SQL