How to query post with meta?

Try: 

 $all_pms =  new WP_Query( [
 'post_type' => 'pms-subscription',
 'post_status'=>'active', 
 'meta_query'=>[
      'meta_key'=>'pms_subscription_plan_price',
      'meta_value'=> '126', // string
      'meta_compare' => '=', // or  > or  < or !=
 ]
] 
);

https://developer.wordpress.org/reference/classes/wp_query/#custom-field-post-meta-parameters

Although ..re-reading your question I’m not sure what you’re exactly looking for..

With this query you’re searching posts of type pms-subscription having post_status =active and custom field with meta_key pms_subscription_plan_price and meta_value equals ‘126’

Related Posts:

  1. How can I get the post ID from a WP_Query loop?
  2. How to edit a post meta data in a Gutenberg Block?
  3. How we get_post_meta without post id
  4. What is the code to get the download link for a product in WooCommerce?
  5. How to update/delete array in post meta value?
  6. Adding an assisting editor box to Post page
  7. How do I retrieve multi-dimensional arrays from the wp_postmeta table, & display on a website?
  8. Why am I getting an infinite loop with have_posts?
  9. How to store post meta in an array?
  10. adding a URL to a post meta
  11. update_post_meta() not working when used with WordPress action
  12. Adding meta data to an attachment post
  13. Get posts by meta value with date
  14. Get updated post meta on save_post action?
  15. Problem With Order Item Meta In Woocommerce
  16. Job of meta_key meta_value fields in database tables
  17. How to store Gutenberg ColourPicker RGBA as metadata
  18. Is it possible to update a post meta field through REST API if the format of it when registered is nested?
  19. Query 2 meta key values and a category
  20. trying to do if post meta !=0
  21. Trying to get file name
  22. Best way to save postmeta
  23. How to add meta data to WordPress posts?
  24. How to update Post Meta values through the comment system
  25. Filtering multiple meta_values
  26. how to build (custom) stats for post views, per month
  27. get_post_meta pagination
  28. How add post_meta from user_meta?
  29. How can I get my iFrame to work with url from post_meta?
  30. Removing Post Meta from Category Pages?
  31. How to use update_post_meta() function properly?
  32. Hey, I want the second options. get_post_meta()
  33. Update post meta in woocommerce order frontend
  34. populate post meta in gravity forms [closed]
  35. How can I filter posts when the meta_value is a serialize object?
  36. Get User Post if Private
  37. How to receive all the meta information of a post ?
  38. How do I dynamically call a page/post author into the meta data?
  39. Set Condition echo function get_post_meta
  40. Unknown characters added to meta data values
  41. Compare old meta with new post meta
  42. get_post_meta($post->ID) returns empty string when in preview mode of custom post type
  43. need to add add user names to the post for later retrieval or removal
  44. Read post meta values, only if posts are public
  45. Like & Dislike functionality using JavaScript
  46. get_permalink vs the_permalink
  47. Time & Date on Post – Time Ago Custom Function
  48. Updating my Post when expiry date is past
  49. Mass removing CSS from 1,700 post [closed]
  50. How to remove Date from Meta Description on SERP?
  51. How to display sql query fired by posts_where
  52. Unfiltered html with update_post_meta
  53. get meta value from page query
  54. Help with Post Meta
  55. why after saving meta value it’s saving all the values the one that i clicked?
  56. How do I manage custom meta in post revisions in the Block Editor era?
  57. Generate metadata for cloud images
  58. Migrating meta value to new meta value
  59. Insert multiple metas in one time
  60. How to extract data from a post meta
  61. count post meta values
  62. Correct meta of Writing Meta Tags
  63. Get post_meta from specific post [closed]
  64. How to add tags to post from frontend?
  65. Retrieve user_meta and copy to post_meta
  66. getting the post_id from the post_meta
  67. Displaying the ‘time ago’ for recent activity within a post/custom post type?
  68. add post meta front end edit
  69. How to query and update one colum in postmeta table?
  70. troubles with get_post_meta (and saving it)
  71. How to save HTML data into SQL post_content column
  72. update post meta value with other post meta value
  73. How to merge the array values in foreach?
  74. Check For get_post_meta on Author Archive Page
  75. Negative meta_query if storing multiple post_meta values with shared meta_key
  76. What format is this and how to get value “lal” and “pila” from it
  77. Frontend query and does not need to log in [closed]
  78. Get data from custom table and update relative post_meta based on meta_key
  79. How to exclude posts by meta key value in the_post_navigation next prev links?
  80. How to save a meta_value as a numeric value after I retrieve it via update_post_meta?
  81. update_post_meta not working with transition_comment_status
  82. Display multiple meta_key/meta_values by single SQL query
  83. Programatically delete several attributes in _product_attributes in post meta
  84. Get post meta after insert post
  85. Data not displaying in text field
  86. How do you sort the items in a custom taxonomy meta box?
  87. WP-API + JS Backbone client – how to update post meta
  88. Proper Way to Sanitize Meta Input
  89. update_post_meta returning false when called during init
  90. post_title in save_post action
  91. Getting meta content from get_next_post & get_previous_post
  92. When importing posts to a new site if XML file has postmeta not setup on new server what happens?
  93. Get value from post meta array, and add it as a category
  94. Access Serialized Post Meta Values
  95. Cache metadata for set of posts
  96. Does post-meta belong in header?
  97. Problem with get_post_meta
  98. wordpress query making site very slow
  99. if condition from post_meta not working in save_post
  100. Extend file format support for post thumbnails
techhipbettruvabetnorabahisbahis forumuedusedusedueduedusedueduedueduedus