Job of meta_key meta_value fields in database tables

Think of them as array key/value pairs (kinda). These tables are used to store additional data about particular posts, comments, or users. The meta_key is the name by which the meta_value is retrieved, plus you have associations with particular posts, comments, or users by means of IDs. As far as structure goes, that is about it. These are “extra info” tables. You can even add to them via the backend. *_postmeta is where the custom fields are stored.

WordPress stores, and plugins and themes can store, a wide variety or information there. Some of those tables have critical information, like role/capability data, but you may also have relatively trivial data like someone’s Jabber handle (Is that even around anymore?), or a favorite color.

Related Posts:

  1. Content hooks vs User hooks
  2. How to get all term meta for a taxonomy – getting term_meta for taxonomy
  3. order by multiple meta_keys?
  4. How to get the total number of meta_values based on a custom post type?
  5. WP_POSTMETA – What do these values mean inside the data structure?
  6. get_*_meta doesn’t always return an array
  7. How can I convert postmeta from unserialized to serialized?
  8. Like & Dislike functionality using JavaScript
  9. why after saving meta value it’s saving all the values the one that i clicked?
  10. Is it safe to add a new field to meta_value field?
  11. How can I use ‘orderby’ => ‘meta_value_num’ to order by the numerical value even if the value starts with a word?
  12. Retrieve user_meta and copy to post_meta
  13. Array of user ids to list of user names
  14. get Insert id for meta field
  15. help to decipher wp metadata
  16. Display current ranking of post as a number in post title
  17. I can not display meta value in extras.php and template-tags.php
  18. Check For get_post_meta on Author Archive Page
  19. Count Post and Page Views based on meta_value Using Shortcode in Dashboard Widget
  20. Negative meta_query if storing multiple post_meta values with shared meta_key
  21. if get_post_meta function returns empty – Do Not Display HTML
  22. How to get the total of two meta values from different meta keys?
  23. How to save a meta_value as a numeric value after I retrieve it via update_post_meta?
  24. How to update/add child posts meta whenever the parent post meta is updated?
  25. show user based on user_meta
  26. Multiple meta key and value search in the query
  27. How to sort by meta value num, but ignore zero value?
  28. Update post meta array – add new, single value
  29. Hide username from blog post source code
  30. How do I retrieve the slug of the current page?
  31. Most efficient way to get posts with postmeta
  32. How to only display posts whose meta_value field is not empty?
  33. Get posts by meta value
  34. Explanation of update_post_(meta/term)_cache
  35. How to extract data from a post meta serialized array?
  36. How to save an array with one metakey in postmeta?
  37. WordPress is stripping escape backslashes from JSON strings in post_meta
  38. How can I get the post ID from a WP_Query loop?
  39. Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
  40. How to update_post_meta value as array
  41. Adding meta tag without plugin
  42. What’s the point of get_post_meta’s $single param?
  43. What is the different between an attachment in wp_posts and an attachment in wp_postmeta?
  44. How to edit a post meta data in a Gutenberg Block?
  45. Sanitizing integer input for update_post_meta
  46. post formats – how to switch meta boxes when changing format?
  47. Execute action after post is saved with all related post_meta records (data)
  48. Lack of composite indexes for meta tables
  49. Get a single post by a unique meta value
  50. if get_post_meta is empty do something
  51. How we get_post_meta without post id
  52. How get post id from meta value
  53. What is the code to get the download link for a product in WooCommerce?
  54. Safe to delete blank postmeta?
  55. Dealing with Many Meta Values, 30+
  56. advanced custom fields update_field for field type: Taxonomy
  57. update_post_meta not saving when value is zero
  58. Can I count the number of users matching a value in a multiple value key?
  59. Meta compare with date (stored as string) not working
  60. Trying to get custom post meta through Jetpack JSON API [closed]
  61. How to update/insert custom field(post meta) data with wordpress REST API?
  62. Restrict post edit/delete based on user ID and custom field
  63. get_post_meta returning empty string when data shows in the database
  64. publish_post action hook doesn’t give post_meta_data
  65. Remove WordPress.org Meta link
  66. Remove post meta keys
  67. How to access the post meta of a post that has just been published?
  68. Why time functions show invalid time zone when using ‘c’ time format?
  69. Why is get_post_meta returning an array when I specify it as single?
  70. How to update/delete array in post meta value?
  71. Adding an assisting editor box to Post page
  72. Building a scalable WordPress favouriting plugin – one serialised meta value array or many meta records
  73. delete unused postmeta
  74. Should I sanitize custom post meta if it is going to be escaped later?
  75. Add post meta based on another post meta value before publish post
  76. How do I retrieve multi-dimensional arrays from the wp_postmeta table, & display on a website?
  77. Front-end update_post_meta snippet displays white screen?
  78. Query between two meta values?
  79. Save both current and new version of post meta
  80. Get Advanced Custom Fields values before saving [closed]
  81. Give extra post-meta to RSS feeds
  82. How to get meta value in wp_attachment_metadata
  83. WP REST API “rest_no_route” when trying to update meta
  84. Clean up output added via wp_head()
  85. List posts under meta_value heading
  86. WordPress Admin Panel search posts with custom post meta values along with title
  87. Why am I getting an infinite loop with have_posts?
  88. Creating a custom post type upon registration
  89. get_post_meta – get a single value
  90. delete value 0 in post meta [closed]
  91. Can I safely delete a record, manually, in the wp postmeta table?
  92. How to store post meta in an array?
  93. What action hook updates post meta?
  94. Can’t translate the post meta data (Date) in another language
  95. get_post_meta / update_post_meta array
  96. adding a URL to a post meta
  97. How to break meta values into different items and avoid duplicates?
  98. Exclude a category from the filed under list
  99. Short of raw SQL, can I query for multiple attachment metadata that have a given array key?
  100. How do I access post meta data when publishing a new post in Gutenberg?