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 ---- ???

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

correct.

I kiss you.
Thanks

Try also

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