title: SQL query: Can't order by column called "order"?
body: <p>I am pulling a column in an existing script into my template files, and everything is working great.</p>
  
  <p>The only problem is, that this script has a column called <code>order</code>, and every row then has a number in that column to show which should be at the top etc. If I set my query to "<code>ORDER BY name</code>" for example, everything works fine, but when I use "<code>ORDER BY order</code>", then I get a SQL error.<br />
  Can I not have a column called <code>order</code>? I can't change column name, because it's part of the script. </p>
  
  <p>Is there a way around it?</p>
  
  <p>This is the line in my SQL query:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM categories WHERE hide = 0 ORDER BY order 
  </code></pre>