title: MySQL: eliminating functions from queries
body: <p>How can I write this mysql query <strong>without</strong> using functions? </p>
  
  <pre><code>SELECT word  
  FROM dvddict 
    JOIN dvdrevdict 
    ON word=RIGHT(revword, 4) 
  WHERE LENGTH(revword)=9; 
  </code></pre>
  
  <p>The dvddict table has a column <code>word</code> and the dvdrevdict table has a column <code>revword</code>, which is just the reverse of the <code>word</code> column. I want to write it without having to use both <code>RIGHT()</code> and <code>LENGTH()</code> functions.</p>
  
  <p>Thanks!!</p>