title: Is it possible to have function-based index in MySQL?
body: <p>I recall in Oracle it is possible to index based on a function, e.g. <code>SUBSTRING(id,1,8)</code>.</p>
  
  <p>Does MySQL support this? If not, is there is any alternative?</p>