Hi
I think the best way to accomplish this task is to:
1- export your MySQL table as a CSV file
2- curate data (select required data, delete other data, and save the csv file)
3- import the csv file using plugins like CSV Importer, which Imports post title, body, excerpt, tags, date, categories etc. I’ve used this plugin to easily import over 500 posts from excel to WordPress.
Best Regards
Abolfazl