title: how to select data from the table which have default key word as a table name
body: <p>I am migrating MSSQL based application to MYSQL and i don't know why but the old developer named table as a 'group' which is a keyword.I tried to run query </p>
  
  <pre><code>SELECT [group] From [groups] where ID !='b0000000-1111-1111-1111-11111111111b' and ID !='e0000000-1111-1111-1111-11111111111e';
  </code></pre>
  
  <p>and also</p>
  
  <pre><code>SELECT group From groups where ID !='b0000000-1111-1111-1111-11111111111b' and ID !='e0000000-1111-1111-1111-11111111111e';
  </code></pre>
  
  <p>but i am getting an error.</p>
  
  <pre><code>Error Code: 1064. 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 '[group]
  </code></pre>
  
  <p>any suggestions?</p>