Update Student Class in MySQL
-- Update class column from numbers to words (1-12)
UPDATE student
SET class = CASE class
WHEN '1' THEN 'ONE'
WHEN '2' THEN 'TWO'
WHEN '3' THEN 'THREE'
WHEN '4' THEN 'FOUR'
WHEN '5' THEN 'FIVE'
WHEN '6' THEN 'SIX'
WHEN '7' THEN 'SEVEN'
WHEN '8' THEN 'EIGHT'
WHEN '9' THEN 'NINE'
WHEN '10' THEN 'TEN'
WHEN '11' THEN 'ELEVEN'
WHEN '12' THEN 'TWELVE'
ELSE class
END;
