Need little help qith SQL query - GoFuckYourself.com

Pics Traffic · 08-14-2008, 02:29 PM

I need to update few rows of data but only for range of entries with ID's between 40 and 100.
so
update table set field='blah-blah' where id ---- ???

nnweb · 08-14-2008, 02:42 PM

update table set field='blah blah' where id >= 40 and id <=100

polle54 · 08-14-2008, 02:44 PM

Quote:

Originally Posted by nnweb

update table set field='blah blah' where id >= 40 and id <=100

correct.

Pics Traffic · 08-14-2008, 02:45 PM

I kiss you.
Thanks

rowan · 08-14-2008, 02:51 PM

Try also

UPDATE table SET field='blah blah' WHERE id BETWEEN 40 AND 100

08-14-2008, 02:29 PM	#1
Pics Traffic Confirmed User Industry Role: Join Date: Jun 2004 Location: Europe Posts: 3,055	Need little help qith SQL query I need to update few rows of data but only for range of entries with ID's between 40 and 100. so update table set field='blah-blah' where id ---- ??? __________________ My Network Is Waiting For Your Fuckin' Trade!

08-14-2008, 02:42 PM	#2
nnweb Confirmed User Industry Role: Join Date: Apr 2004 Location: OC Posts: 720	update table set field='blah blah' where id >= 40 and id <=100 __________________ ONLYFANS MODEL SEARCH \| ONLYFANS MODEL MANAGEMENT

08-14-2008, 02:45 PM	#4
Pics Traffic Confirmed User Industry Role: Join Date: Jun 2004 Location: Europe Posts: 3,055	I kiss you. Thanks __________________ My Network Is Waiting For Your Fuckin' Trade!

08-14-2008, 02:51 PM	#5
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	Try also UPDATE table SET field='blah blah' WHERE id BETWEEN 40 AND 100 Last edited by rowan; 08-14-2008 at 02:53 PM..