SQL学习（2）

条件查询语法

SELECT column, another_column, … FROM mytable WHERE condition AND/OR another_condition AND/OR …;

例子：SELECT * FROM movies where year between  1995 and 2000;

（找到movies中year在1995-2000之间的电影信息） 

语句:SELECT * FROM movies where year not between  2000 and 2010;

(找到movies中year不在2000-2010之间的电影信息) 

语句：SELECT * FROM movies where Length_minutes<120 and year >= 2010

（找到movies中Length_minutes<120并且year >= 2010的数据）

（注意：SQL语句不分大小写；）