What is the best way to mass replace existing products_models without changing products_ids; for a given manufctuer?

By mistake products_models are entered as numeric. Leaving out the manufacturers abbreviation, in-front of the model number.

Need to change from 123456 to GHD-123456.

What is the best way to do this, other than one by one through PHPMyAdmin?