Select between two dates - MySQL Snipplr Social Repository

Revision: 13497

at April 26, 2009 10:16 by craig1709

Updated Code

SELECT * FROM files LEFT JOIN (dates) ON files.uploaded_id = dates.id WHERE date BETWEEN '2009-01-01' AND '2009-12-31'

Revision: 13496

at April 26, 2009 10:16 by craig1709

Updated Code

SELECT * FROM files LEFT JOIN (dates) ON files.uploaded_id = dates.id WHERE date BETWEEN 2009-01-01' AND '2009-12-31'

Revision: 13495

at April 26, 2009 10:15 by craig1709

Initial Code

SELECT * FROM files LEFT JOIN (dates) ON files.uploaded_id=dates.id

Initial URL

Initial Description

Initial Title

Select between two dates

Initial Tags

mysql, date

Initial Language

MySQL