how to select previous row based on date

Question

I have a form where you can enter an date, now in my table i have these fields:

• id
• userid
• timestamp
• value

What I need is the previous record(/date) based on the given timestamp, I really have no idea on how to do this in MySQL.

Any help would be greatly appreciated!

Answer 1

SELECT * FROM table WHERE timestamp < :myTimeStamp ORDER BY timestamp DESC LIMIT 0, 1