SELECT only rows that contain only alphanumeric characters in MySQL

user_158683 0
Viewed 131519

I'm trying to select all rows that contain only alphanumeric characters in MySQL using:

SELECT * FROM table WHERE column REGEXP '[A-Za-z0-9]';

However, it's returning all rows, regardless of the fact that they contain non-alphanumeric characters.

mysql regex
6 Answers

Try this

select count(*) from table where cast(col as double) is null;
user_23536610

Change the REGEXP to Like

SELECT * FROM table_name WHERE column_name like '%[^a-zA-Z0-9]%'

this one works fine

user_12639740
Related