1ALTER TABLE `table_name`
2CHANGE `old_name` `new_name` VARCHAR(10)
3CHARACTER SET utf8
4COLLATE utf8_general_ci NULL
5DEFAULT NULL;
1SELECT CASE lower(col1)
2 WHEN 'agree' THEN 'Ok'
3 ELSE
4 CASE
5 WHEN col2 = 1 THEN 'Ko'
6 ELSE 'Maybe'
7 END
8END AS my_result
9FROM table_name;