Trouble with WHERE clause

[martinlk]

I have a table that looks like this:

description   | value
-----------------------------
"email"       | "[e-mail]"
"password"    | "lickme"

and I want to update the value cell in both rows. I've tried something like this:

UPDATE tablename SET value = "blah" WHERE description = "password", value = "[e-mail]" WHERE description = "email"

This however does not work. I'm guessing that WHERE clauses don't work that way. Anyone know how to do this?

[tasistro]

Can't have two WHERE clauses in the same SQL try

UPDATE tablename SET value = "blah" WHERE description = "password" or description="email"

The WHERE clause is true for both rows and so value is set to blah

[martinlk]

yes but i want to have each row changed into something different and not just "blah" in both rows..

[tasistro]

run two queries, one for each update

[martinlk]

ok thanks

surprised that there isn't a better way though..