direct query to post_meta table

If I understand correctly you wish to retrieve your meta data from the database? Try looking at this WP function: https://developer.wordpress.org/reference/functions/get_metadata/

This will allow you to get the meta data you require dependent on the type of data you want to get, such as post meta data or page meta data etc.

An additional read might be this Stackoverflow question from another user. There are some answers that show how to get the meta data and echo it out.

https://stackoverflow.com/questions/22216276/display-all-post-meta-keys-and-meta-values-of-the-same-post-id-in-wordpress

Related Posts:

  1. How to auto login user again after change user_login
  2. How to Join two tables from separate databases within WordPress
  3. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  4. WPDB: how to get the value of a field in a custom database table
  5. if statement on database query
  6. How to generate page content from database the right way?
  7. phpMyAdmin displays error when importing database
  8. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  9. Transferring working local PHP site to wordpress – with database (MySQL)
  10. Create WP_Query to search for posts by their categories or their parent/child categories
  11. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  12. inserting a post from an extern php file but post content doesn’t show on wp site
  13. Databases – Submitting data from inputs to database [closed]
  14. Is it best to avoid using $wpdb for security issues?
  15. How to retrieve the data from the sever and displaying it in a page?
  16. Lost in trying to create user database system
  17. Filter results from a serialized string to use on statistics
  18. wordpress site – using custom database and PHP
  19. WordPress SQL JOIN query
  20. WP_Query: How to get results from both meta_key options?
  21. get_terms with specific id order
  22. get different meta-data of a complicated query at the same time
  23. add role on WordPress in PHP on a second database
  24. WordPress search query, how to modify the sql
  25. Front end/Database connection in WP
  26. SQL Query Search page
  27. can’t delete a row from post_meta table
  28. Weird Behaviour: Not all WordPress Posts appearing
  29. Can not manually create a database ( db, user, pass ) for a plugin
  30. Querying multiple meta_keys in WordPress SQL query
  31. Custom query_posts() parameter
  32. Execute multiple PHP Snippets causes error?
  33. Retrieve data from external database and insert back in
  34. How to sort search result by post_title, then by post_content
  35. How To Make Connection To WordPress Data Base In A Plugin?
  36. count number of user comments with a specific comment meta value
  37. Duplicates with WP_Query loop
  38. my function doesn’t return my post from today
  39. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  40. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  41. How to create and work with custom data / tables (i.e., for arbitrary data)?
  42. Use wp_get_recent_posts with search term
  43. have_posts() execution failure
  44. Prevent Data Resubmission On Page refresh
  45. SQL QUERY – Select a value directly from the database
  46. Can’t search posts using WP_QUERY inside AJAX Function
  47. How can I use wp_query to show all product data using just the products ID?
  48. Get stock by custom meta field on all Woocommerce variable products
  49. Display fields as values in array from external SQL DB
  50. Getting id of poll from WP database
  51. How does WordPress know wich language is chosen when there is a database connection error
  52. Dynamic content in template
  53. Recent Posts Not Showing Only On A Specific Category Page [closed]
  54. auto-populating custom nav with all items from custom post type
  55. WordPress theme options error
  56. Get posts from multiple post type
  57. WP_Query fails despite having 1 post
  58. How do I display offsite database info on my wordpress site?
  59. the_posts_pagination() not working in wpquery
  60. Use $wpdb or other PHP script method to find/replace in WP database
  61. WP_Query: getting posts where custom field exists
  62. Custom route and query
  63. Getting posts to exclude from array
  64. Custom post type permalinks do not appear using the link functions
  65. array_rand not working correctly?
  66. WP_Query() load selected post
  67. How do I make this Metabox show current DB value?
  68. How to extract information from a wp_query result?
  69. Why when I create a new post I found 2 record related to this post into the posts database table?
  70. mySQL queries are executed twice on wordpress website
  71. wordpress sql posts query won’t display the latest post in a specific category
  72. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  73. WP_Query for woocommerce products with a pattern as a post_title
  74. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  75. How do I make these combination select filters work when only one dropdown is set? They work in WordPress 5.8.2 but don’t in 5.8.3
  76. $_POST returning empty values
  77. How to send custom form submissions to WordPress Database?
  78. Fetch Data from an external MSSQL Database in a Managed WP hosting
  79. Ajax filter with loadmore button
  80. Query by pagename not Working
  81. Display featured image of post type category
  82. Delete post meta by serialized meta value
  83. custom search query database in child theme
  84. How to return count of items found in SQL query
  85. Get meta_query value by user meta array
  86. Where to check in PHPmyAdmin / SQL database for subdomain
  87. Display Year and Month from custom field + Age Calculator
  88. insert thumbnail image from php script
  89. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  90. AJAX Not Working With WordPress Database properly
  91. Masonry layout within the loop
  92. Manipulate database of WordPress site with my own scripts
  93. Problems with plugin that fetches data from database with ajax
  94. How to export database correctly for local to online
  95. How to pass username into form that sends data to database
  96. Insert into db with foreach problem
  97. save array of objects with update_option
  98. How to initialise WP_Query on the basis of a specific meta_value and continue iterating rest?
  99. Can’t insert into a database wordpress
  100. How to get posts by a certain author in inner loop using outer loop variable or post title WordPress