Android :: Finding Auto Incremented Values From An INSERT OR IGNORE Statement In SQLite

I have a table called "images":

CODE:.........

On inserting a row, I'd like the URL column to be unique. At the same time, I'd like to find out the id of the row with that URL.

INSERT OR IGNORE images (url, caption) VALUES ("http://stackoverflow.com", "A logo"); SELECT last_insert_rowid(); -- returns the id iff there was an insert.


Of course, I'd like to do it as quickly as possible, though my first thought was along the the lines of the following pseudo code:

CODE:...........

But this seems hopelessly inefficient.

What is the most performant way of getting the Auto incremented row id from an INSERT OR IGNORE statement.