How to publish a post if condition is met?
I’m trying to have my posts published when wp_posts.ID IN (list).
Is it advisable to do it with an event in MySQL/MariaDB?
Would it mess up the cache?
Is it enough to just do
SET posts_status = 'publish' WHERE wp_posts.ID IN (list)
I found one answer that could be the solution here https://wordpress.stackexchange.com/a/313060/151436
but I’m not really sure how to implement it.
Also, it would be great if a solution had like a minute gap between publishing, so it doesn’t slow down the server.
Any help would be greatly apriciated!