You can edit the post status column in the ‘posts’ DB table. However, you could just use the ‘bulk edit’ feature in admin and do some at a time.
i know i can edit, but i need to change the status of more than 10k jobs.
do you know how can i do this? i need to change the status of more than 10k jobs to “expire jobs”??
thanks!!
Ok, well to do it via mysql you’ll need to write a mysql query to update the post_status column in the wp_posts table to ‘expired’. Or you can use a tool such as PhpMyAdmin to update the rows directly (use the search feature to find all the rows you wish to modify).
sorry but, can you share me the query to do? because im not an sql expert.
thanks!!
Why don’t you use PHPMyAdmin then? its more visual.
i tried by phpmyadmin but i didn’t find where to edit as bulk the status of jobs.
i select al but its not possible, do you know how can i do it?
Browse the posts table and go to search: https://dl.dropboxusercontent.com/s/f04n2sphbf4rx3z/2014-04-20%20at%2020.09.png Then you can filter the results, and you’ll have an option to bulk edit the found rows.