title: MySQL - Column Name already named 'TimeStamp', need to use it in Where Clause
body: <p>What's the proper way to write this query? I have a column named TimeStamp in my customers table. I'm getting errors when trying to find customers who created an account in 2012. I've tried:</p>
  
  <pre><code>SELECT 'TimeStamp' AS CreatedDate
  FROM customers
  WHERE 'CreatedDate' &gt;= '2012-01-01' AND 'CreatedDate' &lt;= '2012-12-31'
  </code></pre>
  
  <p>and also </p>
  
  <pre><code>SELECT *
  FROM customers
  WHERE 'TimeStamp' &gt;= '2012-01-01' AND 'TimeStamp' &lt;= '2012-12-31'
  </code></pre>
  
  <p>and always get no results (there should be thousands)</p>