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