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. a:2:{i:0;i:1272;i:1;i:1995;}

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.