DESCRIBE instances;
INSERT INTO instances (
sequence, shot, asset_group, name, part, datatype, context, variant,
version, active, pub_stts, upld_stts, create_date, user, userdata,
description, vdata, entryfile
)
SELECT
sequence, shot, asset_group, REPLACE(name, '_', ''), part, datatype, context, variant,
version, active, pub_stts, upld_stts, create_date, user, userdata,
description, vdata, entryfile
FROM instances
WHERE name IN ('character_A', 'character_B');