title: Select query with regular expression - MySql
body: <p>I want to select records if a particular column has numbers in its name.</p>
  
  <p>Table 1     </p>
  
  <pre><code>ID   EmpCode    EmpName
  1    1C         Name1
  2    2C         Name2
  3    C3         Name3
  4    CD         Name4
  5    CD         Name4
  6    C6D        Name6
  7    7CD        Name7
  </code></pre>
  
  <p>I need to select records 1,2,3,6,7 based on EmpCode. How can this be performed? </p>
  
  <p><strong>EDIT:</strong> EmpCode can have number in any position</p>