title: Mysql table partition based on last digit of a column/id
body: <p>I want to create partitions based on last digit of employee id, 
  i.e </p>
  
  <p><code>all ids ending with 0 go to first partition</code>, </p>
  
  <pre><code>ending with 1 go to second partition and so on..
  </code></pre>
  
  <p>This way I want to create 10 partitions, employee id can be int or varchar which ever is easy and fast in making partition.</p>
  
  <p>Currently we have 10 separate tables employee_01, employee_02... (dont like this)</p>
  
  <p>Although the retrieval and insertion time will be enhanced by no means, but maintainability would be increased by huge factors, thanks</p>
  
  <p>Edit:</p>
  
  <p>How do I specify partitioning criteria based on last digit of employee</p>