From: william drescher Date: February 12 2013 12:33pm Subject: select and update in the same statement List-Archive: http://lists.mysql.com/mysql/228950 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I am finding I need to retrieve data from a row and also update the 'lastAccess' field in that row. I am using PHP and now do it in two calls to MySQL. Can one of the wizards suggest a way that I can do both in one call ? Not a big deal, just interesting. bill