Thread: SQL question
View Single Post
Old 10-01-2005, 10:35 PM  
Babaganoosh
♥♥♥ Likes Hugs ♥♥♥
 
Babaganoosh's Avatar
 
Industry Role:
Join Date: Nov 2001
Location: /home
Posts: 15,841
Quote:
Originally Posted by sarettah
If the data is stored as a regular datetime field then:

SELECT COUNT(ID) FROM `Members` WHERE Status = 'Active' AND date_format(registration, '%m-%d-%y') ='10-01-05'

Should get you all the registrations for October 1.
The site in your sig cracked me up.

Good stuff. If I weren't a programmer myself I would hire you for everything. I am not a fucking designer however so I might hit you up still.
__________________
I like pie.
Babaganoosh is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote