I have many sticky posts in my database. Is there any SQL function which I could use from phpMyAdmin to change (remove) sticky status of posts, if post is sticky to change it to not sicky.
The sticky posts info is stored in the
sticky_posts option in the options table.
It's stored as serialized array e.g.
You can modify it via the Options API but there's a way to bulk edit posts in the backend:
1. Select the Sticky view:
2. Select all sticky posts and apply the bulk Edit action:
3. Make them non-sticky:
and press update.