title: Replace Non alpha numeric characters with empty string MYSQL
body: <pre><code>select 
      file,
      REPLACE(FILE, '[:alnum:]'+'.'+,'') AS Collection
  FROM
     CollectionData;
  
  
  select 
      file,
  REPLACE(FILENAME, '^[a-zA-Z0-9\.]','') AS Collection
  FROM collectiondata;
  </code></pre>
  
  <p>I would like to replace all the non alpha numeric characters from the string including .file extensions from the string as given below.</p>
  
  <pre><code>AXS00003600.txt  to AXS
  NXS4DG00003600.txt to NXS4DG
  </code></pre>
  
  <p>I am not able to replace the non alpha numeric data when I execute the above query. What could be the problem?  </p>