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.