Order a WP_Query by meta value where the value is an array

At query level? Not possible.

{db_prefix}_postmeta has only one field for value. WP serializes arrays before inserting them and deserializes after they’re out. So you have three choices here:

  1. If you really need this sorting at query level (pagination, maybe?) you have to rethink your information architecture and start using a separate custom_post_meta field for each field that you want to sort by.

  2. Forget sorting.

  3. If your number of items is limited and it’s going to remain limited, you could pull them all out with (posts_per_page=-1) and sort them with array_multisort(). As you might expect, this will slow the page down a bit (depending on the total number of posts that have that particular custom_post_meta).

As a variant to option 1, for performance reasons, depending on number of items and complexity of data, you might consider not using custom_post_meta at all, but store it in a separate custom table.

Related Posts:

  1. Is it possible to retrieve all posts with a certain value for metadata?
  2. WordPress loop by meta key that is an array? and how loop multiple arrays
  3. WP post meta – for loop inside for loop
  4. How to initialise WP_Query on the basis of a specific meta_value and continue iterating rest?
  5. How to update custom fields using the wp_insert_post() function?
  6. How can merge two arrays values in one array and save in database
  7. How to display multiple Post meta_key/meta_values by SQL query
  8. How to use multiple query with same meta key
  9. How to update single value in multi dimensional Post Meta?
  10. Compare two meta key values against each other inside the get_posts array?
  11. How can update custom meta for all posts
  12. Use ajax to update_post_meta
  13. Can an array be used as a meta_query value?
  14. How do I dynamically generate args for wp_query?
  15. how to increase custom post value by one most efficiently?
  16. Use WP_Query in shortcode
  17. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  18. Random order of WP_Query results with highest meta value
  19. How can I create a list of page titles from custom meta values?
  20. Advanced Meta Query for Large Calendar Website (12k+ posts) (175k+ wp_postmeta rows)
  21. How to use $query->set with post__in?
  22. Why do WP_Query results change after updating unrelated Advanced Custom Fields (ACF)?
  23. Store multiple custom field as post meta per post(css, js, html, 2 link) [closed]
  24. How to VAR_DUMP a $variable during checkout process (Is my product meta callable?)
  25. Exclude posts based on meta value
  26. auto-populating custom nav with all items from custom post type
  27. Redirect to another page using contact form 7? [closed]
  28. Advanced Custom Fields – display label and value only if value entered
  29. Non-Closing PHP Query in WordPress Loop
  30. how to get serialized post meta
  31. How to use two meta_compare in an array?
  32. WP_Query: getting posts where custom field exists
  33. How to show meta value code HTML after x paragraph
  34. Remove empty terms from array, sort alphabetically, update back to repeating field
  35. Getting posts to exclude from array
  36. Get all posts as an array ID => Name
  37. How to store multiple custom meta box
  38. extract serialized array to use for wp-query
  39. How can I split my query result in 2 arrays?
  40. array_rand not working correctly?
  41. Add a custom class to the body tag using custom fields
  42. Define category ID using get_post_meta
  43. Hide a div when a custom field is empty
  44. Update value of a associative array with update_post_meta
  45. Using multiple variables to assign categories to an array
  46. WordPress stripping out custom field tags
  47. Add custom fields from different posts
  48. Order category posts by last word of custom field
  49. Add a “custom field” to a category that can be retrieved when viewing the category page with get_post_meta
  50. Sending simple variable on single page to WP JSON
  51. in_array not working on dev server but works on localhost
  52. How to update custom fields when post is published?
  53. Trouble with serialized metadata
  54. Query on a repeater date (acf)
  55. Delete post meta by serialized meta value
  56. Combine multiple queries, array_unique returns nothing
  57. Store custom field’s multiple values in one user meta key
  58. Remove item from post_meta array via AJAX
  59. When working with a post, almost all wp_postmeta are deleted
  60. Updating Lat and Lng of posts automatically gives sporadic results
  61. Efficient way of querying for a “fallback” post?
  62. If custom field doesn’t exist, or exists and it’s true show title?
  63. Metadata on the WP_Post object
  64. WP query with variables gives no result for specific user
  65. Grabbing value of input field inside of array
  66. Display posts in correct month order using single date custom field
  67. Custom route and query
  68. if custom field doesn’t exist, use post thumbnail instead, as image background
  69. change the default order of posts only for specific categories
  70. How can I get all values from my array in a loop in php? [closed]
  71. WP All Import / Update stock quantity from multiple XML files
  72. How to hide posts of a specific custom category in WordPress?
  73. Changing the order of custom fields in the dashboard for Woocommerce variable products [closed]
  74. How to insert wp_users ->user login name to wp_terms when a new user registering?
  75. change order of images attached to post
  76. Post not populating for custom post type based on category selection
  77. Passing an array into WP_Query as a variable
  78. I’m unable to call img path using single quotes in an array?
  79. Custom query vars filters problem with pagination
  80. Custom post type permalinks do not appear using the link functions
  81. Filter by field with array value in ACF on WP REST API
  82. WordPress meta_query >= &
  83. Order BY Most Liked And Published Between Previous Week Monday And Next Week Monday
  84. WP_Query multiple post results
  85. How to add post meta in while loop?
  86. get users search not working with array
  87. Add category to post meta
  88. Modify main query before it run without pre_get_post
  89. Handling repeater data
  90. WordPress WP_Query without query GET parameters
  91. How to add data to a custom field at the wp_users table?
  92. Comapare get_user_meta value
  93. How can get all users by current user meta?
  94. Using rules in Posts
  95. Sort posts in a specific way
  96. Problem with adding custom CSS class to image in ACF Photo Gallery plugin [closed]
  97. Order WP_Query results by meta key value in custom query
  98. Get the id of all images in a post
  99. Output category list inside array
  100. Do not duplicate posts with multiple categories in multiple loops