<div>
This is off the top of my head, but maybe something like (where the month and day have to be set based off of the current day):<br />
<br />

<pre><code id="code-218797">SELECT date_field FROM your_table WHERE month(date_field) = 1 AND day(date_field) = 5
</code></pre>
</div>


This is off the top of my head, but maybe something like (where the month and day have to be set based off of the current day):



SELECT date_field FROM your_table WHERE month(date_field) = 1 AND day(date_field) = 5


<div>
<br />
select ------ from table where date_field = CURDATE();
</div>



select ------ from table where date_field = CURDATE();

<div>
Correct me if I'm wrong, but this query won't automatically figure out today's date, will it?
</div>


Correct me if I'm wrong, but this query won't automatically figure out today's date, will it?

<div>
theGhost_k8:<br />
<br />
The Date in the table is the Date Of Birth. If I understand you correctly, CURDATE() won't find it because the years will be different.
</div>


theGhost_k8:

The Date in the table is the Date Of Birth. If I understand you correctly, CURDATE() won't find it because the years will be different.

<div>
it won't ... mistakes in hurry... 
</div>


<div>
Ah yes, the CURDATE() is a nice touch. I need to brush up on my MySQL =)<br />

</div>


Ah yes, the CURDATE() is a nice touch. I need to brush up on my MySQL =)


<div>
You guys are way too quick. Thanks for all the help. This one did it.
</div>


You guys are way too quick. Thanks for all the help. This one did it.

<div>
<div class="content wysiwyg-content">
I have a MySql Database with the following fields: First, Last, and DOB. (DOB is a Date Field.)<br />
<br />
MySql requires the date to be in the following format: YYYY-MM-DD.<br />
<br />
I am wondering if there is a SQL Query where I can return only those whose Birthdays are today, regardless of what year they were born.<br />
<br />
Thanks
</div>
</div>


I have a MySql Database with the following fields: First, Last, and DOB. (DOB is a Date Field.)

MySql requires the date to be in the following format: YYYY-MM-DD.

I am wondering if there is a SQL Query where I can return only those whose Birthdays are today, regardless of what year they were born.

Thanks

I need a MySQL Query to find anyone whose Birthday is today

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.