MySQL Date() Queries

How to get values from specific dates and months

[wfernley]

Hey everyone,

Well I'm having trouble wrapping my head around the MySQL Date function. I basically have a tracker that tracks clicks on banners on my site. Every time someone clicks a banner, it writes an entry in my database with the banner id and the current date time.

I want to display statistics on my site of these click through rates.

How do I grab data from a specific day, month and year. I figured out how to do it with DATE_SUB(CURDATE(), INTERVAL 10 DAY) but that displays all data between today and that day. I just want to display data for that day.

I'm hoping to get it so it will display the number of clicks each day for the past 15 days and then get it to display number of clicks each month from there on.

Can anyone help me get this figured out?

Thanks in advance for your help! :)

[sned]

You can do something like:

SELECT * FROM tbl WHERE DATE_FORMAT(tbl.datecol, '%Y%m%d') = '20070226';

which would select everything from Feb 26, 2007.

-sned