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

[ Blackhole Pro: Trap and Block Bad Bots ] [ SAC Pro: WordPress Chat Plugin ] [ .htaccess made easy ] [ Wizard’s Collection: SQL Recipes for WordPress ] [ USP Pro - User Submitted Posts ] [ Banhammer Pro: Hammer the Enemy ]

Subscribe to WP-Mix

Project Demos

Popular Posts

Recent Posts

Random Posts

RSS Feed

Grab the RSS Feed ›

1414 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 414 posts. You can check out the latest post published on Aug 29, 2024. Learn more ›

Contact

A few ways to connect:

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