title: MySQL - Select only non - numeric values from varchar column
body: <pre><code>create table mixedvalues (value varchar(50));
  
  insert into mixedvalues values ('100');
  insert into mixedvalues values ('ABC100');
  insert into mixedvalues values ('200');
  insert into mixedvalues values ('EFEA200');
  insert into mixedvalues values ('300');
  insert into mixedvalues values ('AAFASF300');
  insert into mixedvalues values ('400');
  insert into mixedvalues values ('AERG400');
  insert into mixedvalues values ('500');
  insert into mixedvalues values ('AGE500');
  </code></pre>
  
  <p>i want to select only non-numeric(alpha numeric) values, i.e ABC100,EFEA200,AAFASF300,AERG400,AGE500.</p>
  
  <p>i have the code for selecting numeric values, i.e 100,200....</p>
  
  <pre><code>SELECT * 
  FROM mixedvalues 
  WHERE value REGEXP '^[0-9]+$';
  </code></pre>
  
  <p>Please help me,iam a beginner.</p>