MySql query

[alex79]

Any MySql experts here?

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

[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.

[arial]

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]

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]

rm -rf /