title: How in CakePHP update rows with limit and order by conditions
body: <p><br />
  I am trying to update rows with "order by" and "limit" conditions.
  How can i using <b>Model::updateAll()</b> method update rows with "order by" and "limit" ? <br />
  <b>EDIT: </b> <br />
  When i try to execute this query in Model->query() method: "UPDATE table_name SET status = 2 WHERE type = 1 AND status = 1 ORDER BY id asc limit 10", i got error "Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''10'' at line 1". But when i execute this query in mysql console client, all ok.</p>