/*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:]]+";