This question already has an answer here:
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>
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.