Should be a simple one for a mysql guru. What is the mysql equivalent of the following?
select datePart(dd,timestamp) as dayOfMonth, count(timestamp) as searchesPerDay from mytable where (timestamp between '5/1/2012 00:00:00' and '5/31/2012 23:59:59') group by datePart(dd,timestamp) order by datePart(dd,timestamp) asc Thanks, Che ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm