i want to update every row in the mysql table that matches a part of each row in it.
ie. for example if a table contains the following rows : Pid: 21577 PPid: 21174 Uid: 501 Gid: 501 i want to change the first row to Pid: 30209 similarly for any row plz advice me ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]