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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts