How to find the primary key of the most recent insert/update of a specified column value

See more:

MySQL

Hi,

I'm a novice to programming/database administration...is there a MySQL function to find the primary key of the most recent insert/update of a specific column entry?

I have a data base that's using auto_increment as the primary key but one column has multiple entries with the same value but I'm trying to find the MOST RECENT INSERT/UPDATE OF THIS ENTRY.

I know how to write the query to find this but I wanted to know if there's a function.

Here's the query I've written to accomplish the task but if there's a function that does this would someone please let me in on it?

id is the primary key:
Example - SELECT id from table1 WHERE name = "John Doe" ORDER BY id DESC LIMIT 1;