query month and day from bday field

[osusano]

how do u do this?

SELECT bday from tbl_members where month(bday)='02' and days(bday)='11'

from phpmyadmin it gives me error like this

SQL-query :

SELECT bday
FROM tbl_members
WHERE month( bday ) = '02' AND days(
bday
) = '11'
LIMIT 0 , 30

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( bday ) = '11' LIMIT 0, 30' at line 3

[zhabala]

It has to be DAYOFMONTH(bday) instead of DAYS(bday).

Zdenek