MySQL Question

Mysql select users wich have birthday current month

I have stored in database in a varchar column the birthdays like this

dd/mm/YYYY

How can i select the birthday people from current month directly fom mysql query??

And show using php

Thanks

Answer
SELECT
    *
FROM
    yourtable
WHERE
    MONTH(STR_TO_DATE(yourdatefield, '%d/%m/%Y')) = MONTH(NOW())
Comments