How can I compare different rows of different columns in the same table in MySQL

Question

How can I compare different rows of different columns in the same table in MySQL?? I want to get all the data between given Start_Date and End_Date in my database table. But two dates are not in the same row.Ex,

Start_Date    End_Date      Data
2011-07-01    2011-07-31     AA
2011-08-01    2011-08-31     BB

I want to get data between '2011-07-01' and '2011-08-31'.How can I do that? Please reply me with MySQL code.Thanks a lot.

Haim Evgi · Accepted Answer · 2011-08-02 10:24:15Z

1

try

where 
Start_Date between  '2011-07-01' and '2011-08-31' 
OR
End_Date between  '2011-07-01' and '2011-08-31'

answered Aug 2, 2011 at 10:24

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

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

Comments

Sagotharan · Accepted Answer · 2011-08-02 11:21:06Z

0

Are You Want the data between '2011-07-01' and '2011-08-31'. Thats Start_Date is 2011-07-01 or more and End_Date is '2011-08-31' or less.

Am I Correct?. If i correct Try below Query.

SELECT Data FROM table_Name WHERE Start_Date <= '2011-07-01' AND End_Date >= '2011-08-31'

Happy Coding.

answered Aug 2, 2011 at 11:21

Sagotharan

2,62418 gold badges78 silver badges120 bronze badges

Collectives™ on Stack Overflow

How can I compare different rows of different columns in the same table in MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related