in reply to Perl and MySQL update question

Another idea:

Dump the database tables to a file, process the file with a script offline, then load the modified data back into the database. This just uses the same commands you would normally use to create/restore a database backup.