mysql select date inside a date range

Question

I have the following columns:

i need to create a sql statment that I can filter these record with

date_start: 2013-01-17 date_end:2013-03-22

and the found results to be:

does anyone know how to do this?

thank you

This is an issue of determining if date ranges overlap. See [this answer][1] [1]: http://stackoverflow.com/questions/325933/determine-whether-two-date-ranges-overlap/325964#325964 — Charles Bretana, Apr 10 '13 at 16:58

score 0 · Answer 1 · answered Apr 10 '13 at 16:55

0

try this

 select * from your_table where date_start >=  '2013-01-17'
                          and   date_end   <=  '2013-03-22'

answered Apr 10 '13 at 16:55

echo_Me

score 0 · Answer 2 · answered Apr 10 '13 at 16:55

0

SELECT *
FROM table
WHERE date_start BETWEEN '2013-01-17' AND '2013-03-22'
  AND date_end BETWEEN '2013-01-17' AND '2013-03-22'

answered Apr 10 '13 at 16:55

Sammitch

score 0 · Answer 3 · answered Apr 10 '13 at 16:56

0

SELECT * FROM `table` WHERE `date_start` > '2013-01-17' && `date_end` < '2013-03-22'

You will need to replace table with your actual table name in your database.

answered Apr 10 '13 at 16:56

OdinX

3 Answers3