Write between command

Answer 1

You can use in this form Between firstDate And lastDate. It also can perform in this way BETWEEN '01-11-2016' AND '11-11-2016 23:59:34'

Answer 2

SELECT title, place, hour, mDay FROM meetings WHERE MDay BETWEEN '11-11-2016' AND '12-31-2016'

This will list all meetings from 11-11 to the Ende of the year.

Answer 3

'BETWEEN' is basically used for defining range while searching a specific column. It's commonly used on 'DATE' or 'INT' column types. Here are two examples:

SELECT * FROM `users` WHERE `date_of_birth` BETWEEN '2016-01-01' AND '2016-12-31';

SELECT * FROM `users` WHERE `age` BETWEEN '0' AND '18';