We use the plugin Exclude Pages to show or hide pages in the navigation of our WordPress sites.

It’s very useful, but if you suddenly need to show or hide a lot of pages, it becomes tedious and a waste of time to do it through the WordPress backend.

That’s why I looked at how to bulk edit this in the database directly. Start by locating the correct table in MySQL:

Then add or remove page ids as needed. (Note: The numbers that appear here are the pages that are hidden from the user)