title: MYSQL: using des decrypt function with lower
body: <p>I have encrypted user data in my database using des_encrypt, now when i specify a particular statement as below: </p>
  
  <pre><code>SELECT LOWER( DES_DECRYPT( forename, 'ENCRYPT STRING' ) )
  FROM Users
  </code></pre>
  
  <p>All the results are NOT returned in lowercase, anybody know what i am doing wrong? or perhaps how another way to do it? </p>
  
  <p>p.s ENCRYPT STRING is a random character string, not the actual word. 
  Thanks,
  Matt</p>