WP_Query: custom orderby (not ASC nor DESC)

You probably can find some way to make MySQL do the sort for you, but an alternative approach is to make it into an ASC/DESC order by adding additional meta in which you put a numeric sort order value based on whether it is apple, bag, etc and update it when the post is saved. Than all you need to do is to sort by the “sort” meta field.

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. How to use order RAND() on WordPress?
  22. Ordering by meta_value AND date NOT WORKING with wp_query
  23. WP_Query orderby breaks when using AJAX?
  24. Custom Post order for homepage
  25. Change default ordering of taxonomy terms – pre_get_terms
  26. WordPress WP_Query orderby being overwritten
  27. WP_Query Order by Specific Post ID First
  28. Order Posts by meta value AND published date
  29. Sorting posts DESC based on the number of comments using WP_Query
  30. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  31. pre_get_posts order by not working
  32. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  33. Orderby ASC changes to DESC in WP_Query
  34. How to set multiple `orderby` in query argument?
  35. WP_Query order result by date AND meta_value
  36. Order by title without taking into account ‘the’
  37. WP_Query orderby author__in
  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. WP Query – order posts by meta field first and then order the rest
  48. Ordering posts by an array
  49. How to Create a Random List of Child Pages
  50. Specify strict ‘order by’ in WordPress query
  51. Order is breaking wp_query
  52. How order posts from category by date and comment count?
  53. Child pages not affected by orderby
  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. WP_Query orderby random do not repeat infinite scroll – one loop
  59. Sort posts using multiple custom fields and menu_order in single query?
  60. WP_Query order by multiple meta keys & fields
  61. How can I order a post query’s results based on the number of matching taxonomy terms?
  62. How to sort wordpress posts already selected by WP_QUERY
  63. Custom WP Query order function possible?
  64. Custom order of posts in wp_query and different taxonomies
  65. WordPress Query custom ordering by temporary variable
  66. Custom order revolution sliders post base slides as inserted in Specific Posts List field
  67. Meta query orderby meta_value_num sorting by role first
  68. WP_User_Query Orderby Not Working
  69. Order by value of Custom Field using url string
  70. Order posts by tags count?
  71. WP Query with meta queries
  72. Order Element By Custom Field in WordPress
  73. Query Order By Number Variable From API
  74. Order 2 meta_queries differently in WP_Query?
  75. Sorting with meta_query and multiple, optional meta keys
  76. Best way to query posts and order by relevancy to query
  77. Order & Orderby clause not working with custom query
  78. wp_query sorting – one specific meta_key value at last and then sort by create date
  79. Order posts by more than one variable (meta_key and publish date AND time)
  80. Create custom order sortby based on array of id
  81. Best way to Order Post in Home without a plugin
  82. orderby in WP_QUERY – Use the order from the Dashboard
  83. Sort by meta key within same day
  84. Query All Attachments and Order by Parent Publish Date
  85. Using orderby with 2 meta keys
  86. Order posts by custom column using pre_get_posts
  87. Add filter to Orderby Parameter using Array
  88. Order WP_Query results in order other than ASC or DESC
  89. Show sticky post before other WP_Query
  90. Custom query to order by multiple taxonomies
  91. Sorting: custom query with orderby meta_value_num THEN by title
  92. query_posts with sorting on a custom datestamp
  93. Get post closest to today
  94. orderby in WP_query doesn’t works
  95. Posts2Posts, wp_query and orderby issue
  96. Order by meta values
  97. Change posts archive ordering
  98. orderby and order filter in get_posts or WP_query function in wordpress not working
  99. Why does wp_query only display the most recent post when using order ASC?
  100. new WP_Query with order args – no more distinction between categories