Question

MySQL怎么查询一段时间内记录

Answer 1

1. sql 中字段不要加‘ ’ =>滚咐前衡select *, caozuo as caozuo from mj_searched (多此一举吗？ 有*了 还艺大悔纯单独查caozuo)
2. select *, caozuo as caozuo from mj_searched where publishedtime >= '2013-02-12' AND publishedtime <= '2013-03-10';