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. How to log in to phpMyAdmin with WAMP, what is the username and password?
  26. phpMyAdmin access denied for user ‘root’@’localhost’ (using password: NO)
  27. mysqli_real_connect(): (HY000/2002): No such file or directory
  28. Setting up foreign keys in phpMyAdmin?
  29. phpMyAdmin: secret passphrase?
  30. Forbidden :You don’t have permission to access /phpmyadmin on this server
  31. mysqli_real_connect(): (HY000/2002): No such file or directory
  32. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  33. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  34. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  35. MySQL Error #1133 – Can’t find any matching row in the user table
  36. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  37. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  38. How to create a foreign key in phpmyadmin
  39. importing a CSV into phpmyadmin
  40. MySQL: Can’t create table (errno: 150)
  41. MySQL: How to reset or change the MySQL root password?
  42. MySQL Daemon Failed to Start – centos 6
  43. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  44. Auto increment in phpmyadmin
  45. Moving WordPress from MAMP to WAMP, can’t access pages
  46. Moving WordPress from MAMP to WAMP, can’t access pages
  47. How to use “menu_order” field for posts?
  48. Redirecting to old domain after migration
  49. Get current menu_order
  50. Are there any reasons you can’t use strings for admin menu positions?
  51. Order terms by term_order
  52. How do I find all admin users using phpmyadmin?
  53. Adding a menu item in the admin bar
  54. wp_list_categories: order by term order?
  55. What specific database privileges does WordPress need?
  56. How do I order pages and categories by ID or name in the same query?
  57. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  58. Reorder custom submenu item
  59. Manually delete post from database
  60. Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
  61. Menu position (admin menu) of pages
  62. Gaining Login Access via the Database
  63. Reseting admin password through PHPMyadmin fails
  64. How to delete users with no order history through phpmyadmin sql?
  65. How to add an export function to a custom Option Theme Page
  66. Moving database with phpMyAdmin
  67. WordPress altering my custom query, How to fix it?
  68. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  69. WordPress 3.5 Gallery Menu Order not set?
  70. POSTS list in WordPress by views
  71. If orderby parameter using pre_get_posts is the same for multiple posts what fallback does the query use?
  72. How to copy post titles to post slug in phpmyadmin
  73. Delete all post meta except featured image
  74. Export only pages and posts with mysql dump
  75. unable to upload image locally
  76. New page does not get a menu_order
  77. How to do a MySQL dump from production site without using a search and replace script for local development?
  78. How to scroll item in the Menu setting effectively?
  79. How to Move Local Singlesite Database to Remote Multsite Database?
  80. Set Display Name to first and last name (phpmyadmin SQL Query)
  81. Query to change custom post type with specific category
  82. How Do I Merge Categories With phpMyAdmin
  83. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  84. Change default ordering of taxonomy terms – pre_get_terms
  85. How to delete posts that does not have a thumbnail?
  86. Emojis getting converted to “?”
  87. previous next with custom-post-type by order attribute
  88. Page Attachment Permalink Structure based on Menu Order?
  89. How can I restore admin capabilities?
  90. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  91. How to replace values in WordPress DB using phpMyAdmin
  92. How to change admin menu position of “Media”?
  93. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  94. Delete all post meta except featured image Using SQL
  95. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  96. Logout hyperlink within a sub-menu
  97. menu_order not working with slugs that start with admin.php
  98. Importing wordpress. xml file on new installation
  99. Accidentally deleted active_plugins portion of the wp_options DB table
  100. Why do I get a WAMP homepage when clicking on specific website’s URL on LocalHost?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)