MySQL练习9——查找甄嬛传以外的角色信息

select  name,  gender,  age,  Title of TV Series
from  user_profile
where  Title of TV Series <>'甄嬛传';或
select  name,  gender,  age,  Title of TV Series
from  user_profile
where  Title of TV Series !='甄嬛传';或
select  name,  gender,  age,  Title of TV Series
from  user_profile
where  Title of TV Series notin('甄嬛传');或
select  name,  gender,  age,  Title of TV Series
from  user_profile
where  Title of TV Series notlike'甄嬛传';