Right, sorry.

Also elaborating on 1:
Code:
UPDATE table SET column=value, another column=another value... WHERE boolean LIMIT start row, total rows