MySQL IF & CASE Statement

 How to work IF Claus?

IF Claus Syntax:

Code:

IF Clause

SELECT id,name,percentage,
IF(percentage >= 33,"Pass","Fail") AS Result
FROM students;

How to Use Case clause in mysql?

Syntax:

CASE Clause

SELECT id,name,percentage,
CASE
 WHEN percentage >= 80 AND percentage <=100 THEN "Merit" 
 WHEN percentage >= 60 AND percentage <=80 THEN "Ist Division"
 WHEN percentage >= 45 AND percentage <=60 THEN "IInd Division"
 WHEN percentage >= 33 AND percentage <=45 THEN "IIIrd Division"
 WHEN percentage < 33 THEN "Fail"
 ELSE "Not Correct %"
END AS Grade
FROM students;

UPDATE students SET
percentage = (CASE id
 WHEN 3 THEN 39
 WHEN 7 THEN 62
END)
WHERE id IN (3,7);