get the primary key after a DUPLICATE KEY error?

Question

If I run an insert query but it fails because of duplicated key error is there any way to get its primary key without doing another select?

Basically:

INSERT INTO tbl (field) VALUES ('myvalue')

This fails because there is already a record with ID:1 and field:myvalue.

Now I Want to know that ID:1 without doing another query:

SELECT id FROM tbl WHERE field = 'myvalue'

is it possibile?

Answer 1

Here is a link that provides four different ways to deal with this: http://mikefenwick.com/blog/insert-into-database-or-return-id-of-duplicate-row-in-mysql/