How to Query MySQL for Records Created Today?

Understanding MySQL Date Comparison for Today's Date

When working with MySQL databases, it's common to need to retrieve data based on specific date comparisons, such as finding records for today's date.

To retrieve records where the signup date is equal to today, you can modify your SQL select statement by adjusting the WHERE clause:

SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d') 
FROM users 
WHERE DATE(signup_date) = CURDATE()

In this statement:

• DATE(signup_date) extracts the date portion from the signup_date field.
• CURDATE() returns the current date without the time component.
• The equality operator (=) compares the extracted date to today's date.

By using the DATE() function, you ensure that only the date portion of the signup_date field is used for comparison, excluding any time information.

This modified statement effectively retrieves the user IDs and formatted signup dates for users who signed up on the current day, as specified by today's date.

The above is the detailed content of How to Query MySQL for Records Created Today?. For more information, please follow other related articles on the PHP Chinese website!