topr8 - 11:37 am on Oct 20, 2010 (gmt 0)
did you delete the comment?
the sequence i suggested should work, maybe you need to make it all a stored procedure? and then call the stored procedure from your php instead of sending a select statement.
i admit i only use stored procedures for all kinds of reasons, so i'm unsure of the syntax to send multiple queries to mySQL from php
are you doing this from a php page or from another tool directly interacting with the database?
alternatively the obvious workaround is within the php code, query the database to get the required notes then query the database again to update the appropriate field.