Combining two queries.

[Duncan Turner]

I have two queries:

UPDATE tablename SET column=1 WHERE row_id=$id;
UPDATE tablename SET column=0 WHERE row_id<>$id;

But I wish to combine them into one query statement.

Unfortunately I haven't a clue on how to do so.

Could anyone give a helping hand.

Thanks in advance.


Duncan