Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

In what table would I find the title of a custom menu in MySQL for Wordpress 3.5.x?

share|improve this question
add comment

1 Answer 1

Nav menu items are posts of the type nav_menu_item. They are combined to a nav menu by an assigned term from the taxonomy nav_menu. Each nav menu is a collection of posts under a term.

The function wp_get_nav_menu_items() is probably the best start to explore this.

  1. The tables {$prefix}_terms and {$prefix}_term_taxonomy are queried for the current nav menu.
  2. {$prefix}_term_relationships and {$prefix}_term_taxonomy are queried to find the posts assigned to that menu (term).
  3. {$prefix}_posts is queried to get the posts.
  4. {$prefix}_postmeta is queried to get the post meta data.

So the data for a nav menu are spread over four tables.

To see all the queries, add the following to your wp-config.php:

define( 'WP_DEBUG',         TRUE );
define( 'SAVEQUERIES',      TRUE );

The install and activate the plugin Debug Bar, go to a page with a menu and open the debug menu. There is a tab Queries with all the queries WordPress has done for that page.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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