title: Querying a table that has column names with spaces?
body: <p>I am currently trying to get table data that have column names with spaces.</p>
  
  <p>The client has created the database with column names having spaces, the table is joined across other tables, I have tried using the column name in [] and '' but don't seem to work. My query is as follows:</p>
  
  <pre><code>$query = "SELECT appliances.*, location.* FROM (appliances LEFT JOIN location ON appliances.Location ID = location.ID) WHERE Location ID = 11";
  </code></pre>