Ask how to retrieve the month and day (mysql) of this field from the field stored in date format. for example, if there is a birthday stored in, the query conditions can be found, but can I directly read 01 or 18 instead of using PHP for processing? ------ Solution ------------------ correct the answer just now. bi asks how to retrieve the month and day of this field from the field stored in date format (mysql)
For example, if there is a birthday that stores
You can check the query conditions, but can you directly read 01 or 18 instead of reading them and then process them using PHP?
------ Solution --------------------
Correct the answer. you do not need to quote the birthday quotation marks.
You can also
Select MONTH (birthday), DAYOFMONTH (birthday) from table where...
I have tested it, so that you can obtain the data you want.
