Setting several values in one query

[Thora_Fan]

I currenty have a table that has a field called "isCurrent". This field is an enumerated field, ENUM('No', 'Yes'). I am wondering if there is a way in which, when inserting a row, I can set the isCurrent to 'Yes' and the remaining rows to 'No', all at the same time. I know how to do it in two separate queries, but I like to try and minimize the amount of queries I have per page.

Any suggestions?

[barand]

If you have the id of the record you want set to Yes

mysql_query("UPDATE tablename SET Is_Current = IF(id = $id, 'Yes', 'No') )";

hth