mysql between 的用法 ?

Question

mysql between 的用法 

Answer 1

SELECT&nbsp;*&nbsp;FROM&nbsp;`p_archives_3`&nbsp;WHERE&nbsp;`picsad` between 1113 and 1122等同于SELECT&nbsp;*&nbsp;FROM&nbsp;`p_archives_3`&nbsp;WHERE&nbsp;`picsad` >= 1113 and `picsad`<=1122你要保证picsad是数字类型的

Answer 2

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