SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999

The meta_value is not of an integer type for max to return proper values. You can use mysql cast method to convert into integers as follows:

SELECT max(cast(meta_value as unsigned)) FROM wp_postmeta WHERE meta_key='price'

Related Posts:

  1. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  2. Add custom fields to search
  3. Meta Query And/Or
  4. Get emails from users by custom field SQL
  5. Show array of meta_value in Edit Post Coloum
  6. Making WP_Query limit results by date before today where date is a meta_query
  7. get posts based on non-single metadata
  8. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  9. Create Shortcode shows only posts with custom_field meta
  10. WP Query Args – search by meta_key or title
  11. Using meta query (‘meta_query’) with a search query (‘s’)
  12. ORDER BY custom field value
  13. SQL Query to copy value of a meta_key into another meta_key
  14. How to correctly call custom field dates into a posts_where filter using SQL statements
  15. Can I query custom meta data through WP_Query
  16. Meta Query with AND & OR?
  17. What is the advantage of the wp_options design pattern?
  18. How can I display all values of a custom field from posts with a certain value of another custom field or from certain post types?
  19. Retrieving custom fields with $wpdb->get_results
  20. Trying to perform complex custom field query with order by set to field value
  21. Is there a way to do multiple ordering on a multiple meta_query?
  22. Assign/update the custom field value for all posts
  23. Bulk move (or copy) from a custom field to the post content?
  24. Order by custom field date with ASC order
  25. Custom Fields Bulk Edit
  26. Ordering posts by anniversary using only day and month
  27. Calling Specific Pages with wp query Part II
  28. Slow meta query with multi meta keys
  29. Using OR in WP_Query negates the “NOT EXISTS” compare
  30. WP_query : meta_key with custom rule for specific value
  31. How can I combine meta_query queries?
  32. Displaying posts with only upcoming dates according their custom field date value
  33. How to filter a dd/mm/yyyy date from a custom field in a query
  34. Get multiple custom field values in a $wpdb query [duplicate]
  35. Difference between ‘LIKE’ and ‘IN’ in meta queries
  36. Sorting posts by multiple values, combined
  37. WP_Query display next custom post from today’s date
  38. WP_Meta_Query causing long-running MySQL queries
  39. Order by custom field value not working for acf date field
  40. How to sort category by custom field value
  41. trim custom field text value and show (…)
  42. $wpdb query a post type within a specific taxonomy term while ordering posts by custom meta value?
  43. Meta query with timestamp using WP_query
  44. How to wrap meta values seperated by comma in ? [closed]
  45. Custom Field Create Bulk via SQL Query
  46. How to create a Custom Meta Box with Name/Value Admin User Input Fields?
  47. How make a custom search on backend in WordPress without plugin?
  48. How to add a new meta key and assign timestamp to posts
  49. Get content from pages with same meta_key from Database
  50. Run a check for multiple meta key values
  51. Filter by custom field (meta_key) using JSON API
  52. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  53. UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
  54. Alter main archive, to show posts with meta as last
  55. Meta Query returns wrong number of posts
  56. Sort alphabetically by custom field
  57. Use meta_query to get title of associated post
  58. get posts where a custom field contains a text
  59. WP Query – Is this correct?
  60. Avoiding ACF get_field and returning to core WordPress function
  61. pre_get_posts : only get posts by wp_usermeta value
  62. ORDER BY custom field value out of where clause
  63. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  64. meta_value and meta_key filtering returning no posts [closed]
  65. IF Custom field value equals ZERO
  66. List custom field values ​​in alphabetical order without repetition
  67. Build index page from custom fields
  68. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  69. Update post meta custom field using block editor
  70. How to add custom filed value after in wp post title
  71. Sortable Custom Columns not sorting correct
  72. Meta_query ‘compare’ => ‘LIKE’ not working?
  73. Diamond question mark in text after migrating content
  74. query_posts with meta_value
  75. Help setting up a sql query
  76. SQL: Select wordpress posts with given text string and add a custom field to them?
  77. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  78. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  79. multiple meta_query and orderby question
  80. User query – getting values for custom meta keys/fields
  81. Set class if a meta value is set within post archive
  82. WP meta_query args not working in function
  83. Filtering posts by ACF meta query
  84. Why does my numeric meta query work only on one meta key and not the other?
  85. SQL query to change the value of a Custom Field
  86. meta_query to check all custom fields
  87. 4 Unique Random Posts based on Custom Field Values
  88. Update custom table on metabox POST
  89. Fastest and most efficient SQL query to check if UID exists
  90. Query postmeta values, and return multiple post_titles for common meta value
  91. Query Posts Via WordPress URL
  92. Custom Field: Display only if a specific key is selected outside the loop
  93. query specific posts according their custom fields, using sql SELECT
  94. Meta_query not filtering posts
  95. Dynamic background image used in css after selector
  96. Site uses wpdb to fetch meta_keys but just displays first meta_key from a page (the post uses the same meta_key “filmmaker” more than once)
  97. get Custom field label (select/dropdown) on front end
  98. Block Editor – Meta values not saved, meta changes to empty array on update
  99. Sort posts based on an acf field called fecha value return longtext ‘20240517’
  100. Query ‘orderby’ when there are multiple values for the same meta_key

Leave a Comment