SELECT only rows that contain only alphanumeric characters in MySQL

Question

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

User · Answer

Change the REGEXP to Like  SELECT   FROM table name WHERE column name like     a-zA-Z0-9      this one works fine

User · Answer

Try this   REGEXP    a-z0-9       As regexp is not case sensitive except for binary fields

User · Answer

Try this code   SELECT   FROM table WHERE column REGEXP    A-Za-z0-9       This makes sure that all characters match

User · Answer

There is also this   select m from table where not regexp like m     0-9  d       which selects the rows that contains characters from the column you want  which is m in the example but you can change    Most of the combinations don t work properly in Oracle platforms but this does  Sharing for future reference

User · Answer

Your statement matches any string that contains a letter or digit anywhere  even if it contains other non-alphanumeric characters  Try this   SELECT   FROM table WHERE column REGEXP    A-Za-z0-9          and   require the entire string to match rather than just any portion of it  and   looks for 1 or more alphanumberic characters   You could also use a named character class if you prefer   SELECT   FROM table WHERE column REGEXP      alnum

User · Answer

Try this  select count    from table where cast col as double  is null

[mysql] SELECT only rows that contain only alphanumeric characters in MySQL

Examples related to mysql

Examples related to regex