1 vote

Fetch Post Category

If you want to display and fetch all post categories that have posts associated with them and display them in a dropdown list in the WP admin panel, try below the code add in code to your themes ...
vijay pancholi's user avatar
1 vote
Accepted

How to get a list of all posts and their categories?

If you want to export the data to a CSV or JSON file directly from the SQL query, you can use the MySQL INTO OUTFILE clause. SELECT wpd9_posts.post_title, GROUP_CONCAT(wpd9_terms.name) AS categories ...
vijay pancholi's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible