November 22, 2017

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’