Getting posts by custom field value

first, you have to loop through all posts that have this meta key (your custom field) and then update post meta with replacing the word (from) to leave the number alone in the meta value.

//paste the following code in your plugin or theme functions.php
add_action( 'init', function () {
    if ( ! get_option( 'prefix_correct_data' ) ) {
        $metakey = 'YOUR_META_KEY';
        $loop    = new WP_Query( [
            'meta_query' => array(
                array(
                    'key' => $metakey,
                ),
            )
        ] );
        if ( $loop->have_posts() ) {
            while ( $loop->have_posts() ) {
                $loop->the_post();
                $old_meta = get_post_meta( get_the_ID(), $metakey, true );
                update_post_meta( get_the_ID(), $metakey, str_replace( 'from', '', $old_meta ) );
            }
        }
        update_option( 'prefix_correct_data', 1 );
        wp_reset_postdata();
    }
} );

this code cleans the meta value from the word (from). just change the meta key variable with yours

then you can run your wp_query

$posts = new WP_Query( [
    'post_type'  => 'post',
    'meta_query' => array(
        'key'     => 'price',
        'compare' => '<=',
        'value'   => 1000
    ),
] );

make sure to write the word (from) as you will find in the saved custom fields.

— the first function will run one time only and you will have to change the option key to run it again —

Related Posts:

  1. Meta query with string starting like pattern
  2. compare meta_query in get_posts arguments
  3. Getting attachments by meta value
  4. querying with custom meta field with meta_query
  5. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  6. WordPress altering my custom query, How to fix it?
  7. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  8. Order by meta_key in custom post type doesn’t affect the query
  9. meta_key and meta_value not working together
  10. Order Posts by meta value AND published date
  11. How to make Meta Query case sensitive?
  12. Fetch Record based on meta key dates
  13. Meta_query with multiple keys and multiple values
  14. meta_query BETWEEN, but the range is stored in the custom field
  15. Extend product search with meta in WooCommerce
  16. how to make members list directory through wordpress post custom meta key.
  17. Large AND OR query timing out
  18. meta_value_num not ordering all items
  19. meta_compare not comparing whole integer
  20. Display posts with specific value first in query
  21. Get every post with value in meta key
  22. add_query_arg to compare and display events from a certain date
  23. Comparing 2 Decimal Numbers from custom fields and displaying posts
  24. meta_query weird behaviour, static int will work, but not user data
  25. Query multiple post types, but different order for each
  26. Order by the first array within a meta_query
  27. Query ACF relationship field – Comparator IN – Value array
  28. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  29. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  30. How do i create a custom post query when the meta value is an array?
  31. WP Query – grouping posts by same meta key, adding together values from another key
  32. meta_query is overriding default search
  33. Trouble with serialized metadata
  34. Comparing Meta Field date in WPQuery using Meta_Query?
  35. Query against multiple locations within single custom post type post
  36. WP_Query, ACF field and array
  37. Order by Date Custom Field
  38. Query by meta value (add a dropdown of all values)
  39. Order Posts By Custom Field That is an array of objects
  40. Custom WP_query and integrating into theme file
  41. Using custom field as ‘orderby’ value causing post grouping by publish date
  42. Compare meta key separation
  43. query post based on comparison
  44. Get posts by meta value except one post [closed]
  45. WP Query Args – Title or Meta Value
  46. Can I query custom meta data through WP_Query
  47. Does tax_query really beats meta_query in all situations?
  48. Query WooCommerce orders where meta data does not exist
  49. Execute a large WP_Query with many “AND” Meta_Queries?
  50. Query all posts where meta value is empty
  51. WP_Query min and max values
  52. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  53. How to query using a combination of custom_field values?
  54. Revolution Slider Orderby Two Custom Fields
  55. Meta-value query
  56. Meta query field order together with post_date order causes posts without the meta field to be unordered
  57. Display link to taxonomy archive only if it has posts with certain custom field values
  58. pre_get_posts filter meta_query without conflicting existing meta_query
  59. Undefined property: WP_Query::$post
  60. Programmatically set ‘meta_query’ for filter
  61. WP_Query meta_query >= date
  62. Extending woocommerce admin product search
  63. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  64. WP_Query: include custom post type only with specific meta value
  65. Query multiple meta values
  66. Query by multiple meta elements not seeming to work – wordpress is timing out
  67. How does one perform a sub query with different post types
  68. Query posts without meta preload
  69. Query all posts if multiple meta key don’t exist
  70. wp_query to print posts if have X custom field value
  71. meta queries do ‘either/or’ checks
  72. WP Query ordering on a meta field for posts with a date in the future not ordering by datetime
  73. Selecting posts with a given meta value for a meta key
  74. WP_Query: getting posts where custom field exists
  75. How to order posts on each different category?
  76. get_page meta query not working, maybe a bug?
  77. Query by date from custom field
  78. Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
  79. Sort posts using multiple custom fields and menu_order in single query?
  80. Sort custom post by custom field if none order by latest release
  81. Search filter between promo and exact price
  82. WordPress Meta Query Null Values Order
  83. show most viewed post
  84. Unusual high query of user meta data
  85. How to create URL parameters to run custom queries?
  86. WP Query Meta Query
  87. Query custom meta value – post view and date meta
  88. How can I modify standard search query to include also ACF custom fields values?
  89. WP_Query – show posts where meta value and user_email match
  90. Best way to Order Post in Home without a plugin
  91. WP_Query using meta_query with LIKE doesn’t return what it should
  92. Loop through multiple custom fields with increasing number
  93. Return a single custom post from multiple meta queries
  94. new WP_query using custom fields
  95. Including ‘cat’ => $cat breaks meta_query
  96. Query string form $_GET[‘value’] is not working as meta value in wp_query
  97. 294 Queries on Mainpage of WordPress
  98. How to get all post_id and meta_value using meta_key in wp_postmeta table
  99. WP Query – Show custom posts only if user contain some user meta
  100. How do I subquery with custom meta fields?