Ok I'm trying to figure out whether any presidents were born in may and on may 31 by searching a data base. I've been trying various statements and I've tried looking online, but nothing I try seems to work. I 'm using MYSQL 5.
Basically I want it to work like the literal statements shown below, but instead use SELECT MONTH(NOW()); and
SELECT DAYOFMONTH(NOW());:
select fname,lname from president where dob like '%-05-%';
select fname,lname from president where dob like '%-05-31';
Any Help would be greatly appreciated.
Basically I want it to work like the literal statements shown below, but instead use SELECT MONTH(NOW()); and
SELECT DAYOFMONTH(NOW());:
select fname,lname from president where dob like '%-05-%';
select fname,lname from president where dob like '%-05-31';
Any Help would be greatly appreciated.