Skip to content
Read For Learn
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP

How to generate numbers indistinguishable for the IDs of the posts

The post ID must be a number, it can’t an alphanumeric string. The simplest way to force the use of the high numbers for ID’s is to use phpMyAdmin, or some similar database management system, and edit the wp_posts table.

With phpMyAdmin:

  1. Open phpMyAdmin, open wp_posts table, and open Operations tab.
  2. Find AUTO_INCREMENT field, and change it to the number you want to use for your posts.
  3. Click Go to save the new value.

When the next post is created, it will use this value and will go from there. This doesn’t affect previously created posts, and it is not a good idea to mess with them, there are many places where you need to make changes.

Check this out to see the max value allowed for BIGINT field (used for ID), but don’t use the value close to the limit.

Related Posts:

  1. How to publish a post with empty title and empty content?
  2. How to add a “publish” link to the quick actions
  3. how “manage_posts_custom_column” action hook relate to “manage_${post_type}_columns” filter hook?
  4. the_posts filter been called multiple time
  5. How can i do something after head like adding a hook for after head but before post
  6. Modify WP_Post before processing
  7. Prevent posts with certain post_meta to be edited
  8. Update post meta within save_post action
  9. Exists filter or action that change Add New Post link?
  10. the wp_post_update isn’t working all the time
  11. Grab meta data before post is saved
  12. Is it possible to completely replace a post with an action/filter?
  13. Filter question list on substring of metavalue
  14. Modify upload directory to use post category slug in file path on multisite installation
  15. Get post content with all filters applied, knowing post id
  16. Customize rel=canonical tag for single blog post
  17. Change all author links in Blog roll
  18. How to I retrieve the ID from the Posts page?
  19. How to save meta checkbox WordPress
  20. What does WordPress do if I save a post without content/title? [duplicate]
  21. Adding bootstrap classes to video shortcodes
  22. Is it possible to filter the main loop to exclude posts from a specific category?
  23. How to calculate the average of a post meta value(Numeric) of a specific author
  24. query post limits
  25. Is there any way to tell when wp_postmeta has been updated?
  26. wpColorPicker – problem with implementation to post meta
  27. Divs appearing everywhere in post content
  28. Modify posts listing at back end
  29. Filtering posts on Post Administration Page by Week Number instead of by Month
  30. How to check in functions.php if there is data in a WP_Query?
  31. Change post author without using wp_update_post()
  32. Change the default blog post post attribute template name from “default template” to something else
  33. Hook for changing excerpt content when excerpt not set
  34. if in category but only with post meta
  35. Is it possible to add a shortcode below post title?
  36. Post filtering is returning blank page
  37. wp_query with ajax
  38. Display post number by category
  39. Updating post meta for checkbox
  40. Automatically set post_parent value
  41. Saving Post Data in Another Database
  42. Updating permalink structure using ‘post_link’ filter results in 404 error for posts
  43. How include css class based on post ( in loop ) slug?
  44. Custom permalink for each post
  45. How can I tell if a post has been published at least once?
  46. Restrict displaying posts to the poster itself (in Back-end)
  47. Is there a way getting post fields using `transition_post_status`
  48. Automatic blog page with custom design [closed]
  49. Add multiple meta keys to a post at once
  50. Show number of posts by logged in user
  51. How does WP decide how to display a page
  52. When sending a newsletter -not with wordpress- the server has 100% cpu [closed]
  53. Retrieve data from post meta meta_key having ‘_product_fq_image’ while having author_id and post type is PRODUCT
  54. Insert data from custom created PHP page into wp_postmeta table
  55. Adding a meta box to determine the sidebar [closed]
  56. The loop starting at a certain ID
  57. saving/reading custom field value does not work – no value gets POSTed
  58. Simple Custom Metabox Not Saving
  59. Get post category as a separate string and url
  60. changing parent_id on post
  61. wp_list_categories() Exclude All Categories Except One
  62. Get current taxonomy and display query accordingly
  63. Actions to use when flushing cache (when posts are added / deleted / modified)
  64. Trying to exclude custom posts based on date, while sorting by custom field
  65. can’t modify post title using the_posts filter
  66. Show only posts with titles/permalinks that do not contain certain words
  67. How do I display main query posts in random order using add_filter
  68. Featured Images most often doesnt appear
  69. Rewrite image links from attachment id to attachment link
  70. Post meta not working
  71. user_has_cap filter allows “edit_others_posts” but not is not allowing updating/publishing
  72. Using AJAX to filter posts without refreshing page
  73. Is there a way to know when a page has been updated and do some action only once?
  74. How to bulk Update URLs to new values?
  75. Select another post in a post meta like a parent page is selected while editing a page
  76. SQL DELETE multiple post_meta on single and multi-sites
  77. Filter posts by month (dropdown)
  78. Restricting displayed posts to posts from only select authors
  79. Run a function when a custom post is update?
  80. Send email to user when I publish a new post
  81. Display/Filter post using if else statement
  82. How to add a custom class attribute into code wrapper? [duplicate]
  83. Is update_post_meta used when save_post action hook is invoked?
  84. Filtering private Posts
  85. Private post caught in endless redirect loop
  86. How to retrieve all meta data directly from the $post object? Such as $post->related_topics?
  87. What is proper filter or hook action to add data to the $post object?
  88. how to filter posts by category without page load (ajax) in wordpress?
  89. Remove status ‘archived’ from the default post and page view
  90. Count singular post views automatically
  91. Dropdown Select Post Filter
  92. Blogposting Schema & Structured Data without plugin
  93. long-title posts do not want published
  94. Automatically select template based on query string for New Posts
  95. Display Updated Date Instead of Published Date
  96. How to add a block to a category page?
  97. How do you update post date (year only) in a separate custom field?
  98. Add view to admin menu to filter for specific criteria ( If post is child of specific Parent )
  99. How do i search post by jquery datepicker?
  100. Add postmeta to all blog posts
Categories posts Tags actions, filters, post-meta, posts
Register and enqueue style.css custom theme
404 Error on trying to enqueue a JS file

Recommended Hostings

Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

Recent Added Topics

  • Bug in translation system: load_theme_textdomain() returns true, files are available and accessible but the language defaults to english
  • Custom Elementor controls not appearing in the widget Advanced tab using injection hooks
  • Get the name of the template/*html file used
  • Trying to Add Paging to Single Post Page
  • Sharing media files between live and staging servers
  • How to display the description of a custom post type in the dashboard?
  • Critical error on image display
  • Copying WP data and files into new install?
  • How to determine the DirectAdmin WordPress backup date?
  • How to get list of ALL tables in the database?
© 2026 Read For Learn
  • Database
    • Oracle
    • SQL
  • algorithm
  • asp.net
  • assembly
  • binary
  • c#
  • Git
  • hex
  • HTML
  • iOS
  • language angnostic
  • math
  • matlab
  • Tips & Trick
  • Tools
  • windows
  • C
  • C++
  • Java
  • javascript
  • Python
  • R
  • Java Script
  • jQuery
  • PHP
  • WordPress