Ordering posts by an array

This is not possible with native API and you will probably have a rather bad time hacking up SQL for it.

This would be quite trivial to re–sort posts like this after they are retrieved with PHP code. if you use get_posts() you get array you manipulate already and for a WP_Query object array of results is available in public $posts property.

Note this assumes you don’t need to paginate this query. In which case things get very messy very fast and back to the mountain of custom SQL.

Related Posts:

  1. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  2. WP_Query orderby date not working
  3. Order by optional meta key?
  4. Sorting: custom query with orderby meta_value_num THEN by title
  5. Order by DESC, ASC in custom WP_Query
  6. WP_Query order by multiple meta keys & fields
  7. Secondary Sort (fallback) for WP_Query
  8. Query Posts in a Predefined Order
  9. How to get order of posts?
  10. Order posts by ID in the given order
  11. Sorting posts by custom date fields (non standard date format)
  12. How do I order pages and categories by ID or name in the same query?
  13. WP_Query sort by comment meta data
  14. Order posts by tags count?
  15. Merge 2 args in one WP_Query and order it by date
  16. Orderby = none not working [duplicate]
  17. WP_query ‘orderby=none’ Problem
  18. Revolution Slider Orderby Two Custom Fields
  19. Order posts ascending with number in title
  20. List taxonomy terms plus their latest post ordered by post date
  21. Ordering by meta_value AND date NOT WORKING with wp_query
  22. WP_Query orderby breaks when using AJAX?
  23. Custom Post order for homepage
  24. Change default ordering of taxonomy terms – pre_get_terms
  25. WordPress WP_Query orderby being overwritten
  26. WP_Query Order by Specific Post ID First
  27. Order Posts by meta value AND published date
  28. How can I pick a single post from the latest 3?
  29. Sorting posts DESC based on the number of comments using WP_Query
  30. Order WP_Query by multiple fields, subtracting them from one another
  31. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  32. pre_get_posts order by not working
  33. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  34. Orderby ASC changes to DESC in WP_Query
  35. How to set multiple `orderby` in query argument?
  36. WP_Query order result by date AND meta_value
  37. Order by title without taking into account ‘the’
  38. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  39. Weird orderby => post__in issue
  40. Order by summing multiple values
  41. Understanding the orderby in WP_Query?
  42. Order by empty custom field
  43. How to order posts by title after they have already been sorted by category
  44. Advanced ordering of query_posts
  45. Help ordering Post loop by two meta values
  46. meta_value_num not ordering all items
  47. How to Create a Random List of Child Pages
  48. Advanced WP_Query with meta_query, orderby?
  49. Specify strict ‘order by’ in WordPress query
  50. Order is breaking wp_query
  51. How order posts from category by date and comment count?
  52. Child pages not affected by orderby
  53. Filtering by multiple conditions in the loop
  54. WP_User_Query orderby meta_val_num
  55. WP_Query custom order and pagination
  56. Orderby two meta fields not working
  57. Sorting posts by Multiple custom fields in defined order
  58. orderby ignored by wp_query
  59. Sort posts using multiple custom fields and menu_order in single query?
  60. WP_Query order by multiple meta keys & fields
  61. How to sort wordpress posts already selected by WP_QUERY
  62. Custom WP Query order function possible?
  63. Custom order of posts in wp_query and different taxonomies
  64. WordPress Query custom ordering by temporary variable
  65. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  66. WP_User_Query Orderby Not Working
  67. Order by value of Custom Field using url string
  68. Order posts by tags count?
  69. Order by meta date with a thousanth of a second defaults to post order
  70. Order Element By Custom Field in WordPress
  71. Query Order By Number Variable From API
  72. How to get_comments() ordered by date and parent?
  73. Order 2 meta_queries differently in WP_Query?
  74. Sorting with meta_query and multiple, optional meta keys
  75. WP_Query: custom orderby (not ASC nor DESC)
  76. Best way to query posts and order by relevancy to query
  77. Order & Orderby clause not working with custom query
  78. Create custom order sortby based on array of id
  79. Best way to Order Post in Home without a plugin
  80. orderby in WP_QUERY – Use the order from the Dashboard
  81. Query All Attachments and Order by Parent Publish Date
  82. Order Custom Field by Price
  83. Using orderby with 2 meta keys
  84. Order posts by custom column using pre_get_posts
  85. Add filter to Orderby Parameter using Array
  86. Order WP_Query results in order other than ASC or DESC
  87. Show sticky post before other WP_Query
  88. Custom query to order by multiple taxonomies
  89. Sorting: custom query with orderby meta_value_num THEN by title
  90. query_posts with sorting on a custom datestamp
  91. Get post closest to today
  92. orderby in WP_query doesn’t works
  93. Posts2Posts, wp_query and orderby issue
  94. Order by meta values
  95. Change posts archive ordering
  96. orderby and order filter in get_posts or WP_query function in wordpress not working
  97. Why does wp_query only display the most recent post when using order ASC?
  98. How to put posts with some taxonomy on top of others in `pre_get_posts`
  99. WP_Query sort by ACF date field (newest first) with blank dates first
  100. new WP_Query with order args – no more distinction between categories