Answers for "mysql find non alphanumeric characters"

SQL
0

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:]]+";
Posted by: Guest on August-06-2021

Code answers related to "mysql find non alphanumeric characters"

Code answers related to "SQL"

Browse Popular Code Answers by Language