Change media attachment author via mysql query June 5, 2022 by Tarik Billa UPDATE wp_posts SET post_author = [NEW_ID] WHERE post_author = [OLD_ID]