How to get next/previous record in MySQL?

by

next:

select * from foo where id = (select min(id) from foo where id > 4)

previous:

select * from foo where id = (select max(id) from foo where id < 4)

More Related Contents:

  1. INNER JOIN ON vs WHERE clause
  2. MySQL: Alternatives to ORDER BY RAND()
  3. MySQL LIKE IN()?
  4. Auto Increment after delete in MySQL
  5. In MySQL queries, why use join instead of where?
  6. MySQL function to find the number of working days between two dates
  7. MySQL Trigger to prevent INSERT under certain conditions
  8. MySQL “NOT IN” query
  9. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  10. What’s the difference between VARCHAR and CHAR?
  11. Alter a MySQL column to be AUTO_INCREMENT
  12. Importance of varchar length in MySQL table
  13. mySQL :: insert into table, data from another table?
  14. Return 0 if field is null in MySQL
  15. MySQL “between” clause not inclusive?
  16. MySQL syntax for Join Update
  17. SQL – How to transpose?
  18. MySQL remove duplicates from big database quick
  19. How to delete from select in MySQL?
  20. How to delete Duplicates in MySQL table
  21. SQL SELECT to get the first N positive integers
  22. Sorting string column containing numbers in SQL?
  23. Multiple Ranks in one table
  24. The difference between ‘AND’ and ‘&&’ in SQL
  25. How can I make an average of dates in MySQL?
  26. How to combine aggregate functions in MySQL?
  27. What is the best way to generate ranks in MYSQL?
  28. How to find all IDs of children recursively?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment