MySql query - GoFuckYourself.com

alex79 · 06-15-2007, 02:52 PM

Any MySql experts here?

What is the query to return last 10 days, 1 day per row?

Alky · 06-15-2007, 03:00 PM

select date_entered from data_table where date_entered < Date_Sub(now(),interval 10 day) group by date_entered

its something like that, it didn't test it though. date_entered is obviousley a column in your table holding date info.

arial · 06-15-2007, 03:03 PM

You're going to need to provide a little more info than that but you can start off with using this: SELECT * FROM `table` WHERE DATE_SUB( CURDATE( ) , INTERVAL 10 DAY )

alex79 · 06-15-2007, 03:18 PM

Quote:

Originally Posted by Alky

select date_entered from data_table where date_entered < Date_Sub(now(),interval 10 day) group by date_entered

its something like that, it didn't test it though. date_entered is obviousley a column in your table holding date info.

i don't have any tables to select from..
all i can use is curdate() and date_sub or other mysql commands..
but no table to select from..

so, today we are 2007.06.15.. i wand the query to retourn dates from 2007.06.15 to 2007.06.05, one day on each row..

fris · 06-15-2007, 03:21 PM

rm -rf /

06-15-2007, 02:52 PM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	MySql query Any MySql experts here? What is the query to return last 10 days, 1 day per row? __________________

06-15-2007, 03:03 PM	#3
arial Confirmed User Join Date: Jul 2002 Location: Bay Area Posts: 4,012	You're going to need to provide a little more info than that but you can start off with using this: SELECT * FROM `table` WHERE DATE_SUB( CURDATE( ) , INTERVAL 10 DAY ) Last edited by arial; 06-15-2007 at 03:06 PM..

06-15-2007, 03:00 PM	#2
Alky Confirmed User Join Date: Apr 2002 Location: Houston Posts: 5,651	select date_entered from data_table where date_entered < Date_Sub(now(),interval 10 day) group by date_entered its something like that, it didn't test it though. date_entered is obviousley a column in your table holding date info.

06-15-2007, 03:21 PM	#5
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	rm -rf /