Recover registers afected by UPDATE

I am crazy with a problem. I would like to know the best method to SELECT affected rows after an UPDATE. Thanks to all by your help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Recover registers afected by UPDATE

Egor Egorov wrote: Francisco Ivan Anton Prieto [EMAIL PROTECTED] wrote: I am crazy with a problem. I would like to know the best method to SELECT affected rows after an UPDATE. If you set column values to the new (different from current value), you can just use the same WHERE clause