$rows = $dbh->do("UPDATE checkin
        SET    destination =
        (SELECT destination
        FROM checkin
        WHERE firstname='Henry' AND lastname='Rollins')
        WHERE  firstname='Bill' AND lastname='Gates'
") || die "Couldn't insert record : $DBI::errstr";