How to do less than, more than with wpdb (wordpress database)?

Question

How do I do the less than AND greater than $date in wpdb?

$date = ('Y-m-d');

$wpdb->get_results($wpdb->prepare('SELECT * FROM product_history WHERE enddate = "%d";', array($date)));

I wan't to get history where enddate is today or in present time, BUT also more than 0000-00-00.

possible duplicate of [mysql datetime comparison](http://stackoverflow.com/questions/3989385/mysql-datetime-comparison) — Sergiu Paraschiv, Dec 06 '13 at 07:56

Mitul Shah · Accepted Answer · 2013-12-06T08:33:56.850

1

Try this one

$wpdb->get_results($wpdb->prepare('SELECT * FROM product_history WHERE enddate >= CURDATE()'));

It will work definitely.

Incase of Date with Time, you have to select field DATETIME in MySQL and in that case you should run query something like

$wpdb->get_results($wpdb->prepare('SELECT * FROM product_history WHERE enddate >= NOW()'));

Using this query, You can filter data from current time.

edited Dec 06 '13 at 08:33

answered Dec 06 '13 at 08:19

Mitul Shah

1 Answers1