Resetting menu_order to 0 for posts in PHPmyAdmin?

This piece of mySQL code should do the trick. Go into PHPmyAdmin, click the SQL tab and paste this code:

UPDATE wp_posts SET menu_order = 0 WHERE post_type="my_post_type";

This should set menu_order for all posts of the post type of your choice to 0.

Related Posts:

  1. http://localhost/phpMyAdmin/ unable to connect
  2. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  3. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  4. mysql said: Cannot connect: invalid settings. xampp
  5. This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available
  6. Delete a database in phpMyAdmin
  7. PHPMyAdmin Default login password
  8. wamp server mysql user id and password
  9. phpmyadmin “Not Found” after install on Apache, Ubuntu
  10. Delete a database in phpMyAdmin
  11. Making someone a WordPress administrator using PhpMyAdmin
  12. Why am I unable to login to Dashboard after adding myself to admin via phpMyAdmin?
  13. phpMyAdmin displays error when importing database 2
  14. oembed_cache SPAM problem [closed]
  15. Delete all pages (thousands) except a few by their IDs
  16. Recovering a wordpress blog that got corrupted
  17. Importing posts content from csv
  18. duplicate wordpress site on same bdd
  19. I can not access my local PhpMyAdmin control panel
  20. wp_login.php redirects to old domain
  21. Strings from database are not shown correctly
  22. How to change wordpress adminstrator user ‘s ID from 1 to 0?
  23. WordPress database defragmentation
  24. Cannot login to WordPress admin after update
  25. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  26. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  27. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  28. How to create a foreign key in phpmyadmin
  29. MySQL Daemon Failed to Start – centos 6
  30. Auto increment in phpmyadmin
  31. Moving WordPress from MAMP to WAMP, can’t access pages
  32. Redirecting to old domain after migration
  33. Adding a menu item in the admin bar
  34. What specific database privileges does WordPress need?
  35. Reorder custom submenu item
  36. How to add an export function to a custom Option Theme Page
  37. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  38. POSTS list in WordPress by views
  39. How to copy post titles to post slug in phpmyadmin
  40. Delete all post meta except featured image
  41. Query to change custom post type with specific category
  42. How to replace values in WordPress DB using phpMyAdmin
  43. How to change admin menu position of “Media”?
  44. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  45. Delete all post meta except featured image Using SQL
  46. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  47. Is there a way to order posts and custom post types as one group?
  48. phpMyAdmin displays error when importing database
  49. Duplicate posts when posting nulls in records in phpMyAdmin [closed]
  50. Double domain name in category URL-s
  51. How to get_posts where ‘menu_order’ is more than 0/zero?
  52. Delete WordPress posts from URL list sql query
  53. Delete All Product Images in phpmyadmin
  54. Delete all one-word comments
  55. Backup localhost (wamp) database (phpmyadmin) from harddrive files on windows? For WordPress?
  56. Is it possible to create a wordpress database with php code?
  57. Menu items suddenly are displayed all over the page [closed]
  58. MySql query to get posts with all meta and terms
  59. $wpdb to insert html form information
  60. WP CLI can’t delete plugin related table
  61. Connection refused on locahost after importing database?
  62. Bulk delete WordPress posts with phpMyAdmin
  63. echo menu_order value in my theme
  64. Update a buggy installation
  65. How to migrate a database from a server to another
  66. how to get serialized post meta
  67. Changing menu order of a specific plugin in dashboard
  68. Using menu_position to add two entries between Dashboard and Posts
  69. WordPress redirects to old login after migration
  70. Backing up WordPress database and files
  71. SQL: Select wordpress posts with given text string and add a custom field to them?
  72. Phpmyadmin – post editing
  73. Sort get_children by menu_order
  74. How to change my 3000 Published post status to Draft using PHPMyAdmin
  75. Custom admin menu order fails if slugs are complicated
  76. Delete all users with Editor role and their content mysql
  77. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  78. How to bulk delete a certain part of all wordpress posts
  79. When I add metadata, metavalue length is added in to the value in some cases
  80. Is there any defects for using same database prefix in WordPress for multiple sites?
  81. Deleted products from woocommerce are still in the database
  82. syntax error for changing user role from database
  83. Help locating old custom_css in PHP MyAdmin
  84. Adding wordpress posts using phpmyadmin
  85. How to retrieve user data based on role using SQL?
  86. Display query post based on two orderby value in wordpress
  87. Error while submitting form using AJAX and php
  88. Missing latest posts and options after DB migration via phpMyAdmin
  89. How to sort a sub-menu, generated with get_pages(), by the page order instead of alphabetically?
  90. How can I use WP_Query argument ‘Like %..%’?
  91. Get category fixed in dropdown browse categories
  92. Check if a database is well installed
  93. I would like to import two columns into WordPress
  94. Creating and populating custom nav menu (menu-item-position not working)
  95. List CPT by menu_order with children right after parent
  96. How can I set the default ‘orderby’ and ‘order’ parameters for a REST API call?
  97. Can I use WP_Query to find a post with a particular menu_order?
  98. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date
  99. How to use phpspreadsheet reader with $wpdb
  100. Importing data from excel sheet on webpage rather than from within phpMyAdmin