thefollower Posted December 23, 2007 Share Posted December 23, 2007 Hey Was wondering if i have a query which selects all rows in order of ASC by timestamp.... is there a way to also select rows and with the timestamp select a range of "example" : rows between march 07 to august 07. And then also order them by ASC? If so how would it be done? Just curious Link to comment https://forums.phpfreaks.com/topic/82924-range-selection/ Share on other sites More sharing options...
asmith Posted December 23, 2007 Share Posted December 23, 2007 select * from table where your_time_column > march07 AND your_time_column < august07 order by your_time_column ASC Link to comment https://forums.phpfreaks.com/topic/82924-range-selection/#findComment-421722 Share on other sites More sharing options...
drummer101 Posted December 23, 2007 Share Posted December 23, 2007 SELECT * FROM [your table] WHERE [your_time_column] > [date] AND [your_time_column] < [other_date] ORDER BY [your_time_column] ASC tidied up a little, I know I have hard time reading lowercase in my queries maybe someone else does too Link to comment https://forums.phpfreaks.com/topic/82924-range-selection/#findComment-421777 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.