/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 vote139 views1 answer
How to use update trigger in sql
SQL
16 votes142 views1 answer
Mysql mediumint max value
SQL
8 votes144 views2 answers
Between operator
SQL
0 vote156 views1 answer
Adding generated time in row mysql workbench
SQL
27 votes147 views5 answers
Add column in table
SQL
3 votes159 views2 answers
Oracle apex view logs
SQL
1 vote148 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
3 votes149 views1 answer
Get all elements sql
SQL
4 votes141 views3 answers
Order by value mysql
SQL
0 vote152 views1 answer
Oracle exchange subpartition
SQL