How to use ORDER BY and LIMIT with UPDATE?

Question

Its straight forward. I have no multiple tables.

How can I get the following SQL to work?

"UPDATE table SET (...) WHERE (...) LIMIT 2 ORDER BY something"

Answer 1

The keywords have to be in the correct order. Put limit to the end

UPDATE table 
SET (...) 
WHERE (...)  
ORDER BY something
LIMIT 2