Using BETWEEN in MySQL Queries November 22, 2017 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.