条件查询

柯域

已于 2024-09-10 11:38:38 修改

阅读量204

点赞数 2

文章标签：数据库

于 2024-09-10 10:34:03 首次发布

本文链接：https://blog.csdn.net/weixin_45569659/article/details/142091753

版权

AND or OR
=, !=, < <=, >, >=
BETWEEN … AND …
NOT BETWEEN … AND …
IN (…)
NOT IN (…)
LIKE没有用通配符等价于 =
NOT LIKE
% 通配符，代表匹配0个以上的字符
'-'代表1个字符

/* SELECT * from Movies WHERE Id IN(‘6’)
/* SELECT * from Movies WHERE Year BETWEEN ‘2000’ AND ‘2010’
/* SELECT * FROM Movies WHERE Year NOT BETWEEN ‘2000’ AND ‘2010’
/*SELECT * FROM Movies WHERE Id <= ‘5’;
SELECT * FROM Movies WHERE Year >= ‘2010’ AND Length_minutes < ‘120’;
/*SELECT * FROM Movies WHERE Title like ‘Toy Story%’
SELECT * FROM Movies WHERE Director = ‘John Lasseter’
SELECT * FROM Movies WHERE Director != ‘John Lasseter’
SELECT * FROM Movies WHERE Title like ‘WALL-%’
SELECT * FROM Movies WHERE Year = ‘1998’