Using BETWEEN in MySQL Queries

Assuming you have a column in a table of type DATETIME, and you want to filter it based on dates and time as well, BETWEEN will be helpful.

Listing 1. Sample Code

SELECT * FROM table_name WHERE column_name between '2017-06-10' and '2017-06-12 18:00:00'

Please note: Here the first criteria ‘2017-06-10’ is equivalent to ‘2017-06-10 00:00:00’. Hence the filtering happens for all records starting at 00:00:00 hours on 10-Jun-2017 to 18:00:00 hours on 12-Jun-2017.

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.