MySQL check if dates in db include the dates of given date range

Question

I'm new to MySQL. Can anyone help me with this.

I got two dates say From_Date = '2012-04-01', To_Date = '2012-04-17'. I want to get all the details from the table that contains the date within the given date.

Name      Subject  Start_Date  End_Date
Madhu     Science  2011-05-01  2012-05-01
Madhu     Biology  2012-04-01  2012-04-07
Mahesh    Science  2011-05-01  2012-05-01
Jagadesh  Biology  2011-05-01  2012-03-01

My answer should contain:

Madhu   Science
Madhu   Biology
Mahesh  Science

Shakti Singh · Accepted Answer · 2011-06-08 07:14:34Z

2

select * from table_name 
         where start_date >= "2012-04-01" 
               and end_date <= "2012-04-17"

answered Jun 8, 2011 at 7:14

Shakti Singh

86.8k21 gold badges142 silver badges156 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jones Over a year ago

suppose if i hava a data say Madhu Maths '2012-03-03' '2012-04-5' I want to get this data also in my output

Shakti Singh Over a year ago

@jones: Could you explain all the criteria to retrieve result in question itself sorry i did not understand what are you talking about now?

YvesR · Accepted Answer · 2011-06-08 07:20:29Z

1

You can also use BETWEEN statement part.

See mySQL Reference # Between

answered Jun 8, 2011 at 7:20

YvesR

6,2829 gold badges46 silver badges75 bronze badges

Collectives™ on Stack Overflow

MySQL check if dates in db include the dates of given date range

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related