• Gizzmo
  • Senior Member
  • Offline
  • From: Earth, Milkyway Galaxy
  • Registered: 2004-01-27
  • Posts: 762

Topic: mysql query Question

okim tryin to birthday info out of my SQL for this month, in the feild 'birthday' i have there entire birthday like this M-DD-YYYY.

how would i go about pullin all the users with the birthday that begins with this month.

  • From: Gothenburg, Sweden
  • Registered: 2002-07-03
  • Posts: 946

Re: mysql query Question

Something like this might work:

SELECT * FROM list WHERE MONTH(birthday) = MONTH(NOW())

Look att the chapter "Date and Time Functions" in the MySQL Manual for more information.

  • Gizzmo
  • Senior Member
  • Offline
  • From: Earth, Milkyway Galaxy
  • Registered: 2004-01-27
  • Posts: 762

Re: mysql query Question

thanx, just knowing where to start will help alot...


PS man i love this site.