meta_compare seems to be treating values as strings instead of integers as expected

See this question and my answer there query_posts ->using meta_compare / where meta value is smaller or greater or equals…

Basically for the purpose of meta comparison value is always treated as string, because it is passed as such to $wpdb->prepare() method.

Related Posts:

  1. Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
  2. using multiple meta_key and meta_value in query_posts
  3. How can I sort homepage by a meta value?
  4. Unable to get specific value from post meta
  5. Get author total post votes from post meta
  6. Custom query with orderby meta_value of custom field
  7. what is the correct way to compare dates in a WP query_posts meta_query
  8. Can I exclude a post by meta key using pre_get_posts function?
  9. Custom post meta field effect on the performance on the post
  10. How to get custom post meta using REST API
  11. Difference between meta keys with _ and without _ [duplicate]
  12. Orderby meta_value only returns posts that have existing meta_key
  13. What is the index [0] for on post meta fields?
  14. What is “meta_input” parameter in wp_insert_post() used for?
  15. Query Posts or Get Posts by custom fields, possible?
  16. How to enable revisions for post meta data?
  17. The “_encloseme” Meta-Key Conundrum
  18. Best way to programmatically remove a category/term from a post
  19. Using get_post_meta with new_to_publish
  20. Custom field metabox not showing in back-end
  21. So much data in postmeta
  22. Can I count the number of users matching a value in a multiple value key?
  23. When using add_post_meta and update_post_meta, is there any way to give the individual arrays keys?
  24. How to hide meta box values from custom fields list?
  25. Auto sort the wp-admin post list by a meta key
  26. get_post_meta() unserialize issue – returns boolean(false)
  27. What is the advantage of the wp_options design pattern?
  28. Storing meta fields multiple times OR once with multi dimensional array?
  29. Allow user to create instances of custom field
  30. query_posts and only show results if a custom field is not empty
  31. display specific custom fields
  32. Filter archive.php by custom meta
  33. Is there a hook / action that is triggered when adding or removing a post thumbnail?
  34. Meta keywords and descriptions plugin for manually editing meta for each page/post
  35. passing argument to get_template_part() or a better way to code
  36. Is it possible to store arrays in a custom field?
  37. Get updated meta data after save_post hook
  38. Multiple meta values for same meta_key adding on “Preview Changes” hit but not on saving or updating post
  39. Save HTML formatted data to post meta using add_post_meta()
  40. importing data from non-wordpress mysql db
  41. Order posts by custom field and if custom field is empty return remaining posts
  42. Create meta boxes that don’t show in custom fields
  43. Transients vs CRON +Custom Fields: Caching Data Per Post
  44. Unable to save datetime custom meta field using update_post_meta() function
  45. Up/Down voting system for WordPress
  46. post meta data clearing on autosave
  47. Create custom field on post draft or publish?
  48. Display info from custom fields in all images’ HTML
  49. Ordering posts by anniversary using only day and month
  50. get_post_meta fields don’t show up on posts page
  51. Update meta values with AJAX
  52. Query on custom field count?
  53. How to break meta values into different items and avoid duplicates?
  54. copy attachments to another post type and change attachment url
  55. Cannot edit post meta fields with rest API
  56. ajax delete value from custom field array
  57. Save attachment custom fields on front end
  58. How to use pagination with get_post_meta
  59. Copying Custom Meta Values from existing post to a duplicate post
  60. How to use query_posts() with a date filter on a custom field?
  61. Add a post meta key and value only if it does not exist on the post
  62. Move value of one custom field to another
  63. Order posts according to user defined order for meta values?
  64. Displaying posts with only upcoming dates according their custom field date value
  65. Custom fields to save multiple values
  66. Custom fields: In what order are they saved into the DB?
  67. Function to change meta value in database for each post
  68. Get a post_id where meta_value equals something in a serialized meta_value field
  69. Get aggregate list of all custom fields for entire blog
  70. Transition from (classical) serialized custom meta field to (gutenberg) rest enabled meta
  71. Unable to show ACF’s Image Custom Field properly in Genesis Framework [closed]
  72. Custom field value based on other custom field values
  73. meta_value_num sort glitch
  74. Can ordering post list by meta_value cause performance issue?
  75. Order by value in serialized custom field
  76. wp_handle_upload error “Specified file failed upload test” but still creates attachment?
  77. How to save a ToggleControl value in a meta field?
  78. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  79. Saving custom image meta fields
  80. How do I query for a post by custom field?
  81. meta query not showing any results?
  82. How to display Meta Field Value?
  83. MySQL query to set wp_postmeta using term_taxonomy_id value
  84. How to Validate Post Meta type/extension (Video File Image File etc)
  85. Get all meta keys assigned to a post type
  86. how can i use custom field in query post
  87. Custom Meta Box not Saving in Posts with Gutenberg Editor
  88. Query post order by post and desc not working
  89. Adding custom fields (post meta) before/during wp_insert_post()
  90. Combine multiple custom field values into single value
  91. Get specific custom field keys from a post and put into an array
  92. How do I use wp_query for WordPress search?
  93. Nav Menu – Add class based on meta keys
  94. How to query posts with certain custom meta data, and output Post data
  95. MySQL Query that looks for post with Custom Field, then changes Category
  96. Order query by meta_value with multiple custom fields
  97. ACF: How to get the full field name (meta_key) by a field key?
  98. How to wrap meta values seperated by comma in ? [closed]
  99. Bulk remove post meta
  100. post meta getting deleted on save