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! Quote 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...
Solution Barand Posted July 4, 2014 Solution Share Posted July 4, 2014 UPDATE .... WHERE id BETWEEN 100 AND 200 Quote 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 Quote 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 Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.