/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

9 votes293 views1 answer
Mysql check date range
SQL
7 votes271 views3 answers
Postgre describe table
SQL
1 vote278 views2 answers
Mysql join two tables
SQL
0 vote261 views1 answer
Procedures and functions in pl/sql
SQL
-1 vote298 views1 answer
Sql show custom constraints
SQL
0 vote299 views1 answer
PSQL use LIKE with timestamps
SQL
103 votes470 views2 answers
Sql server LIKE '%%'
SQL
0 vote300 views1 answer
Sql alter column name sql server
SQL
0 vote300 views1 answer
C# mysql data reader from two tables
SQL
0 vote278 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL