Retrieve the result by a specific date between a date range

Question

Hi friends I'm using MySQL. I would like to retrieve the result set by giving date in WHERE condition . I have given date range of the start date and end date . I have to compare the date[Today's] with the start date and end date .

for ex : SELECT * FROM tbl WHERE 2015-07-22 is between start date and end date .

Thanks in advance

possible duplicate of [Mysql: Select all data between two dates](http://stackoverflow.com/questions/1080207/mysql-select-all-data-between-two-dates) — Thanos Markou, Jul 22 '15 at 09:45
Did you try `SELECT * FROM tbl WHERE '2015-07-22' BETWEN start_date AND end_date`? — Vatev, Jul 22 '15 at 09:45
@Vatev It returns #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BETWEN start_date AND end_date LIMIT 0, 30' at line 1 — user1894647, Jul 22 '15 at 09:48
Make sure the date constant (today's date) is in quotes (`'`). If that doesn't work post the whole query. — Vatev, Jul 22 '15 at 09:51

score 0 · Answer 1 · answered Aug 06 '15 at 08:40

0

This will work:

SELECT * FROM tbl WHERE '2015-07-22' between start_date and end_date;

What I did:

Added quotes to date
removed "is" before between statement.

answered Aug 06 '15 at 08:40

drunken_monkey

1,760
1
12
14

Retrieve the result by a specific date between a date range

1 Answers1