title: How can I write SQL for a table that shares the same name as a protected keyword in MySql?
body: <p>The following query will not execute </p>
  
  <pre><code>mysql_query("SELECT * FROM order WHERE orderID = 102;");
  </code></pre>
  
  <p>It produces the following error message:</p>
  
  <blockquote>
    <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order WHERE orderID = 102' at line 2</p>
  </blockquote>
  
  <p>How can I write SQL that will successfully query this table?</p>