Daily Archives: July 25, 2008

Updating Substring in Column in MySQL

Today I needed to make the same kind of update to a field in a few rows of a large database table. There were too many rows to do it with a separate SQL update statement per row, so I hunted down the MySQL REPLACE function. Okay, it was only 6 rows, but I needed… Read More »