title: Updating a MySQL column that contains dot (.) in its name
body: <p>I have columns that their names have the structure <code>nameUser.Name</code>, but I'm having trouble updating them. I've tried a few possibilities:</p>
  
  <pre><code>// Ideally, I'd like to do this (since the User.Name is 'dynamic', ie, it depends
  // on who is logged in):
  $userLogged = 'Some.User';
  $columnName = 'name' . $userLogged;
  mysql_query("UPDATE Industries SET '$columnName'='$name' WHERE id='$id'");
  // Another try:
  mysql_query("UPDATE Industries SET $columnName='$name' WHERE id='$id'");
  // Alternatively, if the above cannot be achieved:
  mysql_query("UPDATE Industries SET 'nameSome.User'='$name' WHERE id='$id'");
  // Yet another try:
  mysql_query("UPDATE Industries SET nameSome.User='$name' WHERE id='$id'");
  </code></pre>
  
  <p>Non of the above works, however. Why?</p>