MySQL在两个日期之间选择不按预期工作

Question

I'm trying to create a query that will select all dates between two dates
This is my query:

$query = "SELECT DISTINCT * FROM D1,D2
    WHERE D1.DATE_ADDED BETWEEN '$date1' AND '$date2' AND D1.D1_ID = D2.D2_ID";

The trouble is, it is not returning anything, but not producing an error either

So I tried inputting it directly into phpMyAdmin like this

SELECT DISTINCT * FROM D1,D2
    WHERE D1.DATE_ADDED BETWEEN '2011-01-01' AND '2011-12-12'
        AND D1.D1_ID = D2.D2_ID`

then like this

SELECT DISTINCT * FROM D1,D2
    WHERE D1.DATE_ADDED BETWEEN '2011-01-01' AND '2011-12-12'

and like this

SELECT * FROM D1
    WHERE DATE_ADDED BETWEEN '2011-01-01' AND '2011-12-12'

and I just get

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003 sec )

Yes, my tables exist, and so do the columns :)

Answer 1

If you always want to select an entire year it is easer to select it like this:

SELECT * FROM D1 WHERE YEAR(DATE_ADDED) = 2011;