明智地获取生日数据[重复]

Question

This question already has an answer here:

• mysql: get record count between two date-time 3 answers

I have a dob(DATE) field in table which stores birth dates of users. now i have query to get users who have birth date in this month is as follow

SELECT * FROM register WHERE MONTH(dob) = MONTH(NOW())

Which returns me users who have birthday on this month now i wants to change search from month to datewise means if user are searching date wise so query returns me datewise date

e.g.

user search and variable in php i get as

$fromdate = 09-Mar-2018
$todate = 20-Mar-2018

Now my query should search datewise instead of month wise.

</div>

Answer 1

Send a filter from the front end and backend level use a logic to change the query based on filter, as an example, if you want to check date wise, `

$query = "SELECT * FROM register"; 
if($filter == "dateWise"){ 
$query." "."Where dob = NOW()";
 }else if($filter == "monthWise"){ 
$query." "."Where MONTH(dob) = MONTH(NOW())"; 
}` 

Use this type of thing to achieve your goal.