Hi! can anybody help?
I try to renumber rows in a table. Directly with SQL i would use this expression:
SET @x=0; UPDATE tasks SET lfdnum=(SELECT @x:=@x+2) ORDER BY lfdnum
How would this look like when using cakephp query->update… ?
Thanx for your help!