MySQL get row closest to NOW()

Posted by Christopher McCann on Stack Overflow See other posts from Stack Overflow or by Christopher McCann
Published on 2010-05-10T17:42:21Z Indexed on 2010/05/10 17:44 UTC
Read the original article Hit count: 275

Filed under:

I have a table with User data such as name, address etc and another table which has a paragraph of text about the user. The reason that they are separate is because we need to record all the old about data. So if the user changes their paragraph - the old one should still be stored. Each bit of about data has a primary key aboutMeID. What I want to do is have a join that pulls their name, address etc and the latest bit of aboutMe data from the other table.

I am not sure though how I can order the join to only get the latest about me data.

Can someone help?

© Stack Overflow or respective owner

Related posts about mysql