Ok this is what my table structure looks like:
eadd varchar(40) for email addresses
bday varchar(4) everyone is posting mmdd
emailques varchar(2) they answer yes or no
I want my query statement to tell me what birthdays are today and as a bonus email them on their birthday.
select * from lpbdays where bday = curdate();
That didn't work the closest I got was when I did:
select * from lpdays where bday = 0622 (if I do it manually);
If anyone out there can help me out on this that would be great.