PHP code that generates a MySQL query to copy rows from a table to the same table but with some column values changed.

MySQL copy rows with tweaks

$table = 'some_table';
$columns = implode(',', array(
	'title',
	'description',
	'etc...',
));
$sql = '
	INSERT INTO '.$some_table.' (product_id, '.$columns.')
	SELECT "'.$destId.'", '.$columns.'
	FROM '.$some_table.' WHERE product_id = "'.$origId->id.'"
';