Multiple Conditions/Actions in single query

[Sleidia]

Hello!

Does anyone know if it is possible to have multiple conditions inside a single query?

Condition 1 is : UPDATE table SET mydata = "hello" WHERE condition LIKE 'yes'
Condition 2 is : UPDATE table SET mydata = "goodbye" WHERE condition LIKE 'no'

Having both in the same query is possible? Or do I have to connect to the database
as many times as there are conditions?

Thanks a lot for the help.

 

[gheist]

UPDATE table SET mydata = "hello" WHERE condition LIKE 'yes' or (condition LIKE 'no' and answer LIKE 'maybe')

 

[Sleidia]

Hello Gheist,

Thanks for the feedback. Unfortunately, what you wrote
won't do it.
If you look closely to my post, you'll notice that the
data to store in the db is different in each condition.

The query should write "hello" as mydata WHERE condition LIKE 'yes' but it should right "goodbye" WHERE condition is something else.

Thanks anyway.

 

[gheist]

UPDATE tablee
SET mydata = "hello" WHERE conditionn LIKE "yes",
SET mydata = "goodbye" WHERE conditionn LIKE "no",
SET condition ="wow" WHERE mydata like "me%";

etc