我记得,没有区别。但是,请自己看看是否:
explain plan for SELECt * FROM `table` WHERe `unix_date` BETWEEN 1291736700 AND 1291737300
和:
explain plan forSELECt * FROM `table` WHERe `unix_date` >= 1291736700 AND `unix_date` <= 1291737300
制定相同的计划。

我记得,没有区别。但是,请自己看看是否:
explain plan for SELECt * FROM `table` WHERe `unix_date` BETWEEN 1291736700 AND 1291737300
和:
explain plan forSELECt * FROM `table` WHERe `unix_date` >= 1291736700 AND `unix_date` <= 1291737300
制定相同的计划。