条件查询语法
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语句不分大小写;)