Hello, I have a table that has a varchar column in which I need to change a prefix for all records. Currently there are about 500 records and I did not want to do this by hand. It looks like this:
[data here ] UP05000 UP05001 UP05002 UP05003 The identifier has now changed to EN so each records needs to be EN05000 EN05001 EN05002 etc. Can this be done with a query syntax? Or do I need to do this manually. Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]