WP-Mix

A fresh mix of code snippets and tutorials

Find Password Protected Posts in the WordPress Database

Recently I needed to view all posts that were password-protected. Not finding a WordPress function for this, I wrote a quick SQL command to find all password-protected posts in the WordPress database.

SELECT * FROM `wp_posts` WHERE `post_password` != ''

As written, this command will select all password-protected posts from the wp_posts table. Don’t forget to change the wp_ prefix if your WordPress tables are using something other than the default value.

Learn more

Digging Into WordPressWordPress Themes In DepthWizard’s SQL Recipes for WordPress

WordPress Resources

[ BBQ Pro: Advanced WordPress Firewall ] [ Digging Into WordPress ] [ Wizard’s Collection: SQL Recipes for WordPress ] [ GA Pro: WordPress + Google Analytics ] [ .htaccess made easy ] [ SAC Pro: WordPress Chat Plugin ]

Subscribe to WP-Mix

Project Demos

Popular Posts

Recent Posts

Random Posts

RSS Feed

Grab the RSS Feed ›

1364 readers
Feed Statistics
About the Author

Jeff Starr is a professional developer, designer, author, and publisher with over 15 years of experience. He writes books and tutorials, develops plugins, and runs his own business.

About the Site

WP-Mix is where I share code snippets, tricks, and tips. WP-Mix was launched in October 2012, and now features 409 posts. You can check out the latest post published on May 2, 2023. Learn more ›

Contact

A few ways to connect:

© 2012–2024 Monzilla Media ★ shapeSpace ★ Sitemap ★ Feed ★ Privacy ★ Made in the USA