search for last record

[nikko50]

If I was searching for records with an item id of "200101", how can I tell my query to just retrieve the very last record or most current and not all of them.

[Piranha]

First you should know that a relational database stores everything without sorting. So to be able to do what you want you need some kind of sorting, like a auto-incrementing number or teh date and time you insert things in the database. Then you can do this:

SELECT id, name
FROM table
ORDER BY date ASC // or DESC, I never learn when to use one or the other
LIMIT 0, 1 // Will make sure that just one record is returned