Update Query based on condition

Viewed 5641

I would like to do the following. Update a field based on the value of another field like

update table set if(fielda=1){fieldb=2 fieldc=3}else{fieldd=2 fielde=3}

I know this is not valid mysql but its the best way for me to describe the problem.

2 Answers
Related