在MySQL中，在where后面使用case when

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

CREATE TABLE `student` (   `name` varchar(10) DEFAULT NULL,   `subject` varchar(10) DEFAULT NULL,   `score` int(10) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8   INSERT INTO student VALUES('liming','eng',90); INSERT INTO student VALUES('liming','math',90); INSERT INTO student VALUES('tom','math',93); INSERT INTO student VALUES('tom','eng',91);   select * from student where CASE     when score = 90 then name in ('liming', 'tom')     when score = 91 then name in ('liming', 'tom') END