title: MySQL suffix indexes
body: <p>searching around trying to find a way to <strong>add index on suffix</strong> of a column I couldn't find a solution.</p>
  
  <p>The only thing for partial index which I found is on prefix of index which is:</p>
  
  <pre><code>CREATE INDEX part_of_name ON customer (name(10));
  </code></pre>
  
  <p>from <a href="http://dev.mysql.com/doc/refman/5.1/en/create-index.html" rel="nofollow">12.1.13. CREATE INDEX Syntax</a></p>
  
  <p>I also tried other stuff like:</p>
  
  <pre><code>CREATE INDEX part_of_name ON customer (name(-10));
  CREATE INDEX part_of_name ON customer (RIGHT(name,10));
  CREATE INDEX part_of_name ON customer (SUBSTRING(name,-10));
  </code></pre>
  
  <p><strong>ALL with same error:</strong></p>
  
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax;
  </code></pre>
  
  <p>I would like your help!
  Thank you in advance!</p>