如何使用MySQL从新闻表中选择最近6个月 [英] How to select last 6 months from news table using MySQL

问题描述

我正在尝试选择表中的最后6个月的条目，我有一列名为datetime，并且采用datetime mysql格式.

I am trying to select the last 6 months of entries in a table, I have a column called datetime and this is in a datetime mysql format.

我已经看到许多使用间隔和其他方法的方法-应该使用哪种方法?谢谢

I have seen many ways using interval and other methods - which method should I use? Thanks

推荐答案

使用 查看全文