Re: Update two row values in mysql

[Peter Brawley]

Is this what you mean?

update table1
set x=ff(x=0,1,0)
where count1<= quantity;