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 Quote 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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/82924-range-selection/#findComment-421777 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.