/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 vote174 views2 answers
Sql query examples
SQL
0 vote206 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote200 views1 answer
Oracle merge insert if not exists
SQL
0 vote187 views1 answer
Sql put two columns into one
SQL
0 vote196 views1 answer
Get number of tables in database sql
SQL
0 vote186 views1 answer
Oracle archivemode
SQL
1 vote189 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote185 views1 answer
List column names of multiple tables psql
SQL
2 votes192 views1 answer
How to create sql database
SQL
65 votes320 views6 answers
Sql add column to table
SQL