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';