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;