How to get ID from select/update/insert trio?

[Josh Higham]

I have a table for users (id, name, password, logins) with id being autoincrement. When users log in, I'd like to be able to send a single query and retrieve the id, either inserting a record if it doesn't exist, updating logins if it exists, or in some cases (for similar tables) just select(id) if it exists, or insert (and get the auto_increment id) if it doesn't exist.

The INSERT ... ON DUPLICATE syntax almost does what I want, but doesn't appear to return the id. Is there a way to narrow this down to a single query, or am I stuck doing a select, and then insert/update?

Version 4.1.7

Thanks.