Advertisement

Using a conditional UPDATE statement in SQL

I would like to have an UPDATE statement like this:

 SELECT *
 FROM Employee
 WHERE age = CASE 
 WHEN (age < 20) THEN age=15
 WHEN (age > 20) THEN age= 20

​x
 
 SELECT * FROM Employee WHERE age = CASE  WHEN (age < 20) THEN age=15 WHEN (age > 20) THEN age= 20​

Is this not possible in SQL Server / MySQL? I do not want to use the stored procedures or other things.

Suggest me a suitable way around this problem.

Advertisement

Answer

I think what you want is:

UPDATE EMPLOYEE
SET age =
CASE WHEN AGE < 20 THEN 15
ELSE 20 END

 
UPDATE EMPLOYEESET age =CASE WHEN AGE < 20 THEN 15ELSE 20 END​

Advertisement