/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

5 votes221 views1 answer
Mysql count lines
SQL
5 votes166 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote184 views2 answers
Alter table add multiple columns mysql
SQL
0 vote165 views1 answer
Alter table myisam to innodb
SQL
0 vote165 views1 answer
Sql menampilkan data tabel
SQL
0 vote166 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote164 views1 answer
Sql server current time without date
SQL
0 vote133 views1 answer
Store query result in variable sql
SQL
0 vote193 views1 answer
Automated psql csv export script on windows
SQL
0 vote167 views1 answer
Oracle create job if not exists
SQL