Use Cron to modify posts via sql

Creating your own schedules is a little messy (because they need to be persistent and stored in database), but it is quite easy to hop on one of the native schedules that run twice a day.

add_action( 'wp_version_check', 'my_function' );

function my_function() {

    //stuff
}

As for running actual queries you should use $wpdb for that.

Related Posts:

  1. Export WordPress Posts and Meta Information in CSV format
  2. Delete posts from a post type automatically via Cron
  3. how to get permalink using sql
  4. Sql syntax error
  5. get posts and postmetas in assoc array
  6. Create cron job without a plugin?
  7. How do I find which articles are missing a featured image in The WordPress database?
  8. Bulk update post slugs through database
  9. Get the most repeated post contents from a search?
  10. Multiples Empty Posts were created and cannot delete them
  11. Delete WordPress posts from URL list sql query
  12. SQL query to retrieve all the records that have not indicated category
  13. How to verify wp user password by sql query in wp? [closed]
  14. Get ALL post ID’s export list (Only id’s. Php or sql not important )
  15. Avoiding “Missed Schedule” errors when inserting future posts
  16. WordPress website loads more posts than expected
  17. SQL Command for restoring trashed comments
  18. How to Assign / Move all Deleted post to a category
  19. Migrate posts from category and sub-category via SQL
  20. SQL Bulk Move old posts by one author to another category
  21. Export all posts to import as product items
  22. How can I get posts from 9/13/11 to today with SQL? [closed]
  23. Change published date and time using SQL query for page in every 5 hour
  24. SQL DELETE multiple post_meta on single and multi-sites
  25. Bulk find & replace on WordPress posts/pages (minus image paths)
  26. SQL query: select duplicate posts – but using duplicate meta [duplicate]
  27. WordPress MySQL Search and replace with wildcard?
  28. Using a meta_value or postdate to to query and orderby
  29. insert post fails after multiple postings
  30. Adding wordpress posts using phpmyadmin
  31. How to run select query of post with category and tags?
  32. Export Posts with specific custom fields by sql
  33. Query to get data of a post, if in category?
  34. Can’t create posts with WP DB Abstraction Plugin
  35. SQL query to remove first image in all posts
  36. Delete junk text from all the post using my sql command
  37. Special Query: Title, Terms, Content – %LIKE%
  38. If meta_key exists then don’t select this post?
  39. The page that displays Posts on homepage
  40. Change permalinks in posts via SQL
  41. Batch Scanning and Deleting Empty WordPress Posts
  42. How to disable content pagination?
  43. How to add/assign or change featured image in post programmatically?
  44. WP-CLI Bulk delete posts from specific category
  45. Update all posts automatically when using post_meta
  46. Moving WordPress to new server: no posts found
  47. Exclude ALL posts from sub categories
  48. Post ids are incrementing by an unknown number?
  49. Can’t show comments count per post outside loop
  50. Redirect based on user post count
  51. Should our pages be posts?
  52. Allow role to delete posts but block him the wp-admin
  53. Posting via email, where do I start troubleshooting?
  54. Creating a Post, can authors be ordered by last name?
  55. Get permalink of post that an attachment is linked to
  56. open selected wordpress post with javascript
  57. do_shortcode within post query
  58. How to change the setting so there is no post on home page
  59. How should I add links to other pages/posts from my post?
  60. problems with loading posts in a table-row
  61. How to have posts have a parent in permalink like site.com/blog/postname
  62. Unable to restore from backup – how to obtain old blog posts?
  63. Second comments section for one post/page
  64. Why Query is returning empty array?
  65. meta_value timestamp older than now
  66. Total number of posts in query (category/tag/author/search results/main page…)
  67. Very complex post query
  68. Change the number of excerpts displayed in search results layout
  69. Echo Text If User Is Logged in But NOT the Author of post
  70. Getting Whitescreen when publishing a post [closed]
  71. add div after image in post [closed]
  72. How do I link a Post Type to a Template in Masterplan?
  73. How can my plugin display a populated new post window
  74. Where is the “Posts”/”Blog” template?
  75. How to get posts ordered by using their categories?
  76. How to get value in radio input in post meta box?
  77. ACF date picker to trigger category change
  78. wordpress admin missing Posts button
  79. Set post title font size automatically according to number of words in post title
  80. post and page and custom post type
  81. How can I use query_posts to loop through posts and construct my own content?
  82. How to make an image appear as a thumbnail in the blog post?
  83. If I moved the location of my generic “posts” page, do I need to change the slugs for all of the individual posts?
  84. Not display post meta if empty
  85. post_name is not stored until post is published… where should I store my slug until it goes live then?
  86. Adding div to WordPress page content
  87. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  88. Super post cleaner, could this be category specific?
  89. How to organise post by category and date
  90. Show post if in category
  91. How to display custom content in post with category XXX
  92. Get current post’s child page?
  93. How to include Related Posts in WP RSS feed
  94. retrieve post slug by post_tags taxonomy
  95. Hide the contents for specific post
  96. Display post structure in function
  97. Filter/Sort Post Form On Taxonomy page
  98. sub posts to parent post
  99. Display post by select it from a dropdown menu
  100. I am using the query block and what I want and see on the editor page is not the same with the actual results