MySQL选择datetime字段，其中date等于今天

Question

I am trying to select a datetime field where the date equals today. However, the query never returns any rows.

I have this row in my database:

id    booked_at
1     2015-08-05 09:10:56

The query i'm using is:

select date(`booked_at`) from `booking_dates` where booked_at = CURDATE();

Why is this not returning the row above?

Answer 1

You have to strip the time part of booked_at because 2015-08-05 09:10:56 is not equal to 2015-08-05. Try this:

select date(booked_at) from booking_dates where date(booked_at) = CURDATE();