title: MySQL SELECT with URL Decode
body: <p>Is there a way to perform a MySQL query and have one of the columns in the output directly urldecode, rather than have PHP do it.</p>
  
  <p>For example this table 'contacts' would contain,</p>
  
  <pre>------------------------------------
  |name      |email                  |
  ------------------------------------
  |John Smith|johnsmith%40hotmail.com|
  ------------------------------------</pre>
  
  <pre><code>SELECT * FROM `contacts`
  </code></pre>
  
  <p>Would output,</p>
  
  <blockquote>
    <p>John Smith | johnsmith%40@hotmail.com</p>
  </blockquote>
  
  <p>Is there something along the lines of,</p>
  
  <pre><code>SELECT name, urldecode(email) FROM `contacts`
  </code></pre>
  
  <p>To output,</p>
  
  <blockquote>
    <p>John Smith | johnsmith@hotmail.com</p>
  </blockquote>