/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 vote219 views1 answer
Liquibase alter column type / length
SQL
0 vote272 views1 answer
Regex mongoose
SQL
0 vote237 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
3 votes237 views3 answers
Create table in microsoft sql server
SQL
3 votes213 views2 answers
Oracle apex view logs
SQL
0 vote187 views1 answer
Cara menampilkan user di mysql terminal
SQL
1 vote204 views1 answer
Error code 1292 mysql workbench
SQL
1 vote154 views1 answer
Insert into sql
SQL
0 vote208 views1 answer
Less than and between in sql query
SQL
0 vote229 views4 answers
Forenkey code alchemy sql
SQL