Date: 04/22/06 (PHP Community)    Keywords: php, mysql, database, sql

Whilst using PHP and MySQL I noticed that I just get an error if I try to update (or do anything with) any field with the names unique and read in the database, forcing me to have to change the names in teh database.

For instance, I'd get an error if I do this:
$sql = "UPDATE support SET read=1 WHERE error_id=$id"; mysql_query($sql);

At the moment to counter that, I've had to rename 'read' to 'opened' and it works fine, but I was just wondering if there was a way that I could actually use 'read' without getting an error.

Source: http://community.livejournal.com/php/442711.html