0

Write between command

12th Nov 2016, 6:43 PM
Ayush Sharma
Ayush Sharma - avatar
3 Réponses
+ 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'
12th Nov 2016, 7:24 PM
Klaid Begeja
Klaid Begeja - avatar
0
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.
12th Nov 2016, 6:54 PM
jmey
0
'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';
15th Nov 2016, 11:03 PM
Satyendra Chaudhary
Satyendra Chaudhary - avatar