title: MySQL PDO - how to deal with question marks in field names
body: <p>I've inherited a MySQL database that has field names like the below:</p>
  
  <p><code>'Profile is Subscribed ?'</code> &amp; <code>'Private ?'</code></p>
  
  <p>These can't be changed as the table is used by different systems within the business.</p>
  
  <p>But, I want to use PHP PDO to update these records.</p>
  
  <p>For example: <code>UPDATE Guests SET `Profile is Subscribed ?` = :subscribed, `Private ?` = :private WHERE intID = 123;</code></p>
  
  <p>But, when using placeholder's I'm getting the "mixed name and positional parameters" error message.</p>
  
  <p>Is there a work around for this (that doesn't involve renaming the fields)? Can I escape the question mark (I've tried "/?", but no difference)?</p>
  
  <p>Thanks</p>