k4pil Posted March 8, 2006 Share Posted March 8, 2006 Hi there people.I have a table called activity in my database as follows;ID acID time page1 2 20060307205835 CRM Home 2 2 20060307205838 View customer detail 3 2 20060407205847 Inventory Home Page 4 2 20060407205911 CRM Home 5 2 20060607205916 Inventory Home Page 6 2 20060607212811 View Cases Screen 7 2 20060707212834 Create Case Screen I want to query this databse from a certain time to a certain time.I have got the query working;SELECT * FROM `activity` WHERE time REGEXP '20060307*' it returns everything starting with that, ignoring the digits after (those represent time so can be ignored).I want to be able to search from a date e.g 20060307 to 20060707. Any one have any idea how i can do this?? Link to comment https://forums.phpfreaks.com/topic/4388-help-with-querying-database/ Share on other sites More sharing options...
greycap Posted March 8, 2006 Share Posted March 8, 2006 If theyre numbers,SELECT * FROM activity WHERE time BETWEEN 2006030700000 AND 2006070700000If theyre dates, then you can use BETWEEN TO_DATE(start) AND TO_DATE(end). etc. Link to comment https://forums.phpfreaks.com/topic/4388-help-with-querying-database/#findComment-15280 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.