[Jon]

Something like:

UPDATE `wcm_cdseo` SET `cdseoTitle` = CONCAT('Product Keyword ',cdseoTitle) WHERE cdseoType='product';

UPDATE `wcm_cdseo` SET `cdseoTitle` = CONCAT('Category Keyword ',cdseoTitle) WHERE cdseoType='category';