problem in updating a table...

[bravo]

hi
i am having a situation where i have to update a whole column and set one value true and rest false For example If the table have two columns Name and Status respectively...
Name Status
aTrue
bFalse
cFalse

and if status of b is set to true now then all other status should be false

aFalse
bTrue
cFalse

is this possible with only runnign one query or i have to run two query one for updating all to False and then second to update a particular record to True
any suggestions....
Thanks in advance

[amitpatel66]

hi
i am having a situation where i have to update a whole column and set one value true and rest false For example If the table have two columns Name and Status respectively...
Name Status
aTrue
bFalse
cFalse

and if status of b is set to true now then all other status should be false

aFalse
bTrue
cFalse

is this possible with only runnign one query or i have to run two query one for updating all to False and then second to update a particular record to True
any suggestions....
Thanks in advance

Try this:

[code=sql]

UPDATE table1 SET status = (CASE WHEN name = 'a' THEN TRUE ELSE FALSE END)

[/code]

[bravo]

thanks a lot amit it worked perfectly....

[amitpatel66]

You are welcome :) .

[ronverdonk]

Try this:
[code=sql]UPDATE table1 SET status = (CASE WHEN name = 'a' THEN TRUE ELSE FALSE END)[/code]

That is a neat one amitpatel6!

Ronald

[amitpatel66]

That is a neat one amitpatel6!

Ronald

Thanks Ron :) .
I will take that!! :)