/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

2 votes369 views1 answer
Sql string_agg
SQL
2 votes358 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote1.2K views1 answer
Mysql custom sort order
SQL
0 vote365 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote337 views1 answer
Postgresql inline table
SQL
2 votes331 views1 answer
Sql like variable
SQL
0 vote388 views1 answer
Insert value in identity
SQL
0 vote341 views1 answer
Select odd records sql
SQL
6 votes380 views2 answers
Mysql convert timestamp to date
SQL
10 votes333 views4 answers
Fetch first 5 characters of the string in sql
SQL