Returning value after insert

Hi, Is there a way of after a select statement having a return value for a determined field ? For example, after this: INSERT INTO wl_users(name, email, password) VALUES('Deckard', '[EMAIL PROTECTED]', 'blabla') having the name returning without having to make a subsequent select. Any help

RE: Returning value after insert

- From: Deckard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 11:40 AM To: mysql@lists.mysql.com Subject: Returning value after insert Hi, Is there a way of after a select statement having a return value for a determined field ? For example, after this: INSERT INTO wl_users(name