update multiple rows using limit in mysql?

by

If you really must do it this way, you can use something like this:

 UPDATE messages SET test_read=1
 WHERE id IN (
     SELECT id FROM (
         SELECT id FROM messages 
         ORDER BY date_added DESC  
         LIMIT 5, 5
     ) tmp
 );

More Related Contents:

  1. MySQL, update multiple tables with one query
  2. UPDATE multiple rows with different values in one query in MySQL
  3. Multiple Updates in MySQL
  4. mysql update column with value from another table
  5. MySQL/SQL: Update with correlated subquery from the updated table itself
  6. What are differences between INSERT and UPDATE in MySQL?
  7. MySql – Way to update portion of a string?
  8. MySQL UPDATE syntax with multiple tables using WHERE clause
  9. The best way to remove value from SET field?
  10. Update MySQL with if condition
  11. Update multiple rows with multiple ‘where’ clauses for each individual row
  12. MySQL update statement to store ranking positions
  13. Using LIMIT within GROUP BY to get N results per group?
  14. How to perform grouped ranking in MySQL
  15. MySQL Trigger after update only if row has changed
  16. MySQL “WITH” clause
  17. Ordering by specific field value first
  18. MySQL “Group By” and “Order By”
  19. How to change the CHARACTER SET (and COLLATION) throughout a database?
  20. MySQL Query to select data from last week?
  21. Mysql 1050 Error “Table already exists” when in fact, it does not
  22. MySQL “IN” operator performance on (large?) number of values
  23. How to get the latest record in each group using GROUP BY? [duplicate]
  24. Advanced MySql Query: Update table with info from another table
  25. How do I count columns of a table
  26. Difference between two table structure
  27. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  28. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  29. Why MySQL is giving error “Not allowed to return a result set from a function”?
  30. When to use a left outer join?

Leave a Comment