title: pdo update statement using concat is not working
body: <p>I am still new to PDO and am having trouble getting the update statement below to work.  I want to be able to update the name field by just appending to the current value with a comma and the new name.  Resulting name field should be like james,doug,paul,etc.  This is probably a simple answer but I haven't been able to find a solution through a lot of googling!</p>
  
  <p>Thanks in advance</p>
  
  <pre><code>    $stmt = $db-&gt;prepare('UPDATE table SET name = concat(name, ',' :name) WHERE id = :id');
      $stmt-&gt;execute( array('name' =&gt; $name, 'id' =&gt; $id) );
  </code></pre>