mysql between 的用法 ?

Question

mysql between 的用法 

Answer 1

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

等同于

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

你要保证picsad是数字类型的

Answer 2

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