mysql between 的用法

2025-05-22 08:41:36

推荐回答（4个）

回答1：

这要看picsad字段是什么类型,

如picsad字段是数字类型,该语句应该这么写:
SELECT * FROM p_archives_3 WHERE picsad between 1113 and 1122

如picsad字段是字符串类型,该语句应该这么写:
SELECT * FROM p_archives_3 WHERE picsad between '1113' and '1122'

回答2：

SELECT * FROM `p_archives_3` WHERE `picsad` between 1113 and 1122

等同于

SELECT * FROM `p_archives_3` WHERE `picsad` >= 1113 and `picsad`<=1122

你要保证picsad是数字类型的

回答3：

貌似没什么错误。和
SELECT * FROM `p_archives_3` WHERE `picsad` >=1113 and picsad<=1122是等价的

回答4：

SELECT * FROM p_archives_3 WHERE picsad > 1113 and picsad < 1122

SELECT * FROM p_archives_3 WHERE `picsad between 1113 and 1122 and picsad <> 1113 and picsad <>1122