[EMAIL PROTECTED] (Adv. Systems Design) writes: > I was simply going by the docs themselves: > http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html > (see bottom of page)
yes, using REPLACE may be a solution. But you have to make a copy of the original table, because REPLACE cannot access the values of the old row directly. I'd prefer to do this in the mysql way - on the php side. > Now before you get your flamethrower out...yes I AM > KIDDING...I realize that mysql is maturing and all > these "features" will EVENTUALLY make it in... Some compromises are necessary when using mysql, but often the advantages prevailing. Lutz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php