Query MySQL Table For Records Changed Between Time Period

Goal: Search all users who were updated between a certain time period (in our case one day).

Scenario: A system wide glitch caused a set of users to have all of their last names changed to Smith. Your manager wants to know how many records are affected.

MySQL offers 2 or more ways this can be accomplished. First using <= and >=  the second using BETWEEN operator.

The between operator is identical to >= and <= and is inclusive. Notice the difference in order between the 2 queries.

In order for this query to work the field must be either datetime, timestamp, or date. If using date then remove the time portion from the query.

Demo on SQL Fiddle.

Share this Story
Load More Related Articles
Load More By Nick Escobedo
Load More In How-To's

Check Also

PHP Enums in 60 Seconds

Learn the basics of PHP enums in 60 ...