MySQL练习13——where in和not in

select  name,  gender,  age,  Title of TV Seriesuniversity,  dynastygpa
from  user_profile
where  Title of TV Series ='甄嬛传'or Title of TV Series ='苍兰决'or Title of TV Series ='武林外传';  或
select  name,  gender,  age,  Title of TV Seriesuniversity,  dynastygpa
from  user_profile
where  Title of TV Series in('甄嬛传','苍兰决','武林外传'); 或
select  name,  gender,  age,  Title of TV Seriesuniversity,  dynastygpa
from  user_profile
where  Title of TV Series NOTIN('铁齿铜牙纪晓岚','康熙王朝');