mysql batch update process

I need to batch update balances of some users in members table, how should mysql query be?

MembersArray = array(1,3,4);
AmountToBeAdded = 10;

members

id. balance
1.  45
2.  15
3.  0
4.  120
5.  80

Thanks already for your help

>Solution :

UPDATE members SET balance = balance + 10
WHERE members.id IN(1,3,4)

Leave a Reply