mysql query problem

Question

id   url                    start        end
1    http://yahoo.com      2010-10-17    2010-10-10
2    http://google.com     2010-10-15    2010-12-11
3    http://espan.com      2010-10-20    2011-01-20
4    http://espan.com      2010-10-01    2011-01-01

if Today is 2010-10-16..

how can I get results work in today.

2    http://google.com     2010-10-15    2010-12-11
4    http://espan.com      2010-10-01    2011-01-01

2010-10-17 is greater than 2010-10-10. The start date is supposed to be less than/equal to end date, right? — Salman Arshad
– Salman Arshad, Commented Dec 13, 2010 at 9:14

Tony · Accepted Answer · 2010-12-13 09:11:19Z

2

SELECT id, url, start, end
FROM Your_Table
WHERE 2010-10-16 BETWEEN start AND end

Replace 2010-10-16 with CURRENT_TIMESTAMP or equivalent in MySQL

answered Dec 13, 2010 at 9:11

Tony

10.4k3 gold badges51 silver badges78 bronze badges

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

Comments

bassneck · Accepted Answer · 2010-12-13 09:13:29Z

2

SELECT * FROM your_table WHERE CURDATE() >= start AND CURDATE() <= end

answered Dec 13, 2010 at 9:13

bassneck

4,0434 gold badges27 silver badges32 bronze badges

Comments

Salman Arshad · Accepted Answer · 2010-12-13 09:19:22Z

1

Something like this?

SELECT *
FROM that_table
WHERE CURRENT_TIMESTAMP BETWEEN start AND end

Note that:

in the above example, both dates are "inclusive"
in the above example, CURRENT_TIMESTAMP includes the "time" part as well

edited Dec 13, 2010 at 9:19

answered Dec 13, 2010 at 9:12

Salman Arshad

274k85 gold badges450 silver badges540 bronze badges

Collectives™ on Stack Overflow

mysql query problem

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related