Technical Blogs and Discussion Board

Category: date

Deleting records before a certain date in Mysql

Hi, I was looking for a query to delete the records up to certain date from my MySql table. It’s pretty simple. Here is the MySql table: We have a Delete button in our web page. By clicking on it, it asks for the Date up to which user can delete the data. Once user…

Read More

Querying date with just month and day argument in MySql with PHP

While We were working on a web portal, one of the use case was to send the greeting email to the members on their birthday and anniversaries. Here we had to get all the email ID’s from the database whose birthday is today. And we set the crone job to execute this script(script to send…

Read More