I have a MYSQL DB and I need to do some text manipulation on one of the fields. This is a one-off, not an ongoing process.
The built in MySQL text manipulation functions will be a nightmare to do what I need to do. Perl can do it in a few lines, and I even have a perl script hanging aorund with the exact text manipulation commands needed.
Dumping the table to a text file, Perling it, and then restoring it would work but is a bit cumbersome; is there an easier or better way to use perl to manipulate the data within the mysql DB to cycle through each row in the table, edit the data in a field, and move on the the next row?