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
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