load post data into mysql

I’m not sure of having understood what you are asking for. But if my guess is correct, you can achieve this goal by using $wpdb global variable.

But, in order to be more specific, I need to know how and when you want the database to update those informations.

Related Posts:

  1. MySQL Query to Retrieve Category from wp_posts
  2. SQL Query for getting all posts in their latest revised state
  3. Search & Remove Specific Shortcode From All Posts
  4. Manually delete post from database
  5. How to force update all posts after import
  6. Query All users that has post
  7. Can’t publish new posts
  8. Manually removing revision post types
  9. Reset/Reorder posts ID in the MySQL wp_posts table
  10. How do I find which articles are missing a featured image in The WordPress database?
  11. Tags to Post-ID mysql query. Tag Search
  12. wp_insert_post – duration
  13. Get user categories with most posts in it
  14. MySql query to get posts with all meta and terms
  15. Custom order for Mysql array
  16. List authors with the last post title and order by last post date
  17. How to Mysql select a list of posts with meta_values AND all relevant categories?
  18. Remove a shortcode from all WordPress posts
  19. Order posts alphabetically: how to set order=asc in mysql query?
  20. What do these phpMyAdmin errors mean on my WordPress databaes?
  21. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  22. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  23. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  24. update image path with words starting uppercase to lowercase chars
  25. Queries take 120+ seconds on my large WordPress site
  26. Database hacked – random posts are modified
  27. Need to change all links in page content but not in post content
  28. Can’t update WordPress Page if post_content is Empty
  29. Restore woocommerce orders
  30. How to select particular month post from table and update the post status using MySQL?
  31. How do post IDs work in WordPress?
  32. Get author posts count after excluding a category
  33. get last post’s link with SQL query
  34. query for filtering published posts?
  35. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  36. Deleting post tags removes categories
  37. Return records between two meta datetimes saved as strings
  38. WP query taxonomy optimization
  39. MYSQL: Create SQL query to search for string and replace
  40. Query to fetch custom taxonomy along with post title
  41. Mysql update menu_order problem
  42. Bulk find & replace on WordPress posts/pages (minus image paths)
  43. WordPress MySQL Search and replace with wildcard?
  44. Add postmeta to all blog posts
  45. ‘posts’ table should not store the absolute image path
  46. Dev and prod on the same database- dev version active for IOS
  47. SQL trigger failes with post_content
  48. Converting Posts to Pages
  49. How to change the publishing date of each posts?
  50. SQL query to remove first image in all posts
  51. Delete junk text from all the post using my sql command
  52. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  53. How to create a post based on data in a table?
  54. If meta_key exists then don’t select this post?
  55. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  56. How to manually delete post from database without causing conflicts?
  57. How to prevent posts from being published too close to each other?
  58. Change the Slug of Post Type post to baseurl/post/%postname%
  59. Exclude posts that only have the ‘Uncategorized’ category [duplicate]
  60. How do I programmatically add an image to a post?
  61. problem to delete page
  62. Get user’s most published categories
  63. How To Remove Certain category Posts From the Blog Page
  64. Add icon/badge next to posttitle of specific category
  65. Too many connections to server
  66. delete_post hook – deleting multiple items
  67. How do I exclude the current post from listing in recent posts
  68. Custom Post Archive Page not working
  69. posts_per_page option limits the number of Gallery items
  70. show custom post type category dropdown sorting result on same page
  71. singular posts using archive styling
  72. Un-highlight Blog Menu Item when Category Menu Item is Selected
  73. How to get the form code from the edit page of a specific post?
  74. Send email for pending post
  75. Get the post id from a plugin
  76. change the post time on multiple posts
  77. Making posts permalinks consistent numbers
  78. How to show category based post in home page?
  79. Locally change the font family [closed]
  80. WordPress single.php different layouts projects / posts
  81. WordPress Post via e-mail writes a random string for the post body
  82. Export post another site
  83. Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
  84. Add Categories To Custom Post
  85. Display post on main page with thumbnail
  86. Display Posts by Categories
  87. Custom Single Post Type not referring to single-post-type.php File
  88. Custom template for different post types
  89. index.php is only displaying current month’s posts?
  90. prevent same wordpress post title
  91. Remove duplicated posts in the loop if post has more than one category
  92. “Current” class on a singular page menu item with custom post types?
  93. get next/previous post name
  94. Get image paths from RSS feeds
  95. How do I display the next 3 posts in the sidebar?
  96. 2 tick boxes appearing below comments
  97. How can to use the players from the Media Widgets in the body of a post to play audio and video files
  98. How to get post ID after removing that post?
  99. I cannot see the pagination in /wp-admin posts page
  100. Insert Tag in WordPress Post