eldan88 Posted July 4, 2014 Share Posted July 4, 2014 Hey Guys. I have tried looking this up on Google but the only answers I am finding is using there where clause. I wanted to know if I can update or delete a range of rows like from id 100-200. Is there a way to do that? Thanks! Link to comment https://forums.phpfreaks.com/topic/289441-how-can-i-update-or-delete-a-range-of-rows/ Share on other sites More sharing options...
Barand Posted July 4, 2014 Share Posted July 4, 2014 UPDATE .... WHERE id BETWEEN 100 AND 200 Link to comment https://forums.phpfreaks.com/topic/289441-how-can-i-update-or-delete-a-range-of-rows/#findComment-1483871 Share on other sites More sharing options...
eldan88 Posted July 5, 2014 Author Share Posted July 5, 2014 Wow. Thanks Barand. I never knew there was a between operator Link to comment https://forums.phpfreaks.com/topic/289441-how-can-i-update-or-delete-a-range-of-rows/#findComment-1483897 Share on other sites More sharing options...
gizmola Posted July 5, 2014 Share Posted July 5, 2014 Yes, but between is the same as WHERE t.foo >= {low} AND t.foo Link to comment https://forums.phpfreaks.com/topic/289441-how-can-i-update-or-delete-a-range-of-rows/#findComment-1483902 Share on other sites More sharing options...
eldan88 Posted July 5, 2014 Author Share Posted July 5, 2014 Ohh okay. Got it gizmola! Thank you! Link to comment https://forums.phpfreaks.com/topic/289441-how-can-i-update-or-delete-a-range-of-rows/#findComment-1483968 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.