Friends, I am transitioning my site from MySQL to PDO. There was a convenient usage in MySQL like this: $result = mysql_query("UPDATE members SET views = views + 1 WHERE member_id = '$replying_member_id'"); However, the same format does not work in PDO. Instead of retrieving the 'views' data separately, incrementing it, and then using it in the update query, does anyone know how I can handle it in PDO in a single line?