Order by empty custom field

There are two solutions for that:

1. Make sure that all posts have that field set.

You can do this easily – just use save_post hook and set it to default value. (You should also add default values for already existing posts that don’t have that field set.)

2. Use a little bit modified query

$faqArgs = array(
    'post_type' => 'faq',
    'meta_key' => 'faq-order',
    'order' => 'ASC',
    'orderby' => 'meta_value_num',
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key' => 'faq-order', 
            'value' => 'bug #23268', 
            'compare' => 'NOT EXISTS'
        )
    )
);
$faq = new WP_Query($faqArgs);

Related Posts:

  1. Loop through multiple custom fields with increasing number
  2. WP_Query vs get_posts
  3. Usage of the new “posts_clauses” filter in WordPress 3.1?
  4. WP_Query: query posts by ids from array?
  5. How to get order of posts?
  6. Order posts by ID in the given order
  7. Custom WP_Query order by post_meta and (author) user_meta
  8. Sorting posts by custom date fields (non standard date format)
  9. pre_get_posts with get_posts
  10. How to order posts tag by tag?
  11. Query Custom Meta Value with Increment
  12. Identify which loop you are hooking into; primary or secondary?
  13. WP_Query ordered by custom field that is a date string?
  14. Group posts by custom field
  15. Order posts by tags count?
  16. Order posts by date and then by custom field
  17. Revolution Slider Orderby Two Custom Fields
  18. Transient pagination not working properly
  19. meta_query on a date range using an array of values
  20. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  21. Show all parents and children in custom post type in right order
  22. Custom Post order for homepage
  23. WP_Query Order by Specific Post ID First
  24. Order Posts by meta value AND published date
  25. Undefined WP_Query::has_posts()?
  26. Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
  27. if/else on custom query gives 200 OK when condition not met?
  28. Upcoming Event: How do I sort database by custom date field, but ignore past dates?
  29. Add quicklink to in the Admin posts page where I can query by a meta_key
  30. How to Filter Posts by Custom Fields?
  31. How to orderby multiple meta fields if some fields are empty
  32. Orderby is working with one query but not with other
  33. Weird orderby => post__in issue
  34. Get a list of posts with associated meta_value
  35. Order by summing multiple values
  36. Understanding the orderby in WP_Query?
  37. How to order posts by title after they have already been sorted by category
  38. Check if loop has any categories?
  39. meta_value_num not ordering all items
  40. How to get list of posts from permalinks?
  41. Is_single() conditional tag returns null in query
  42. Transient api Caches confused
  43. Include current post into loop
  44. WP Query – order posts by meta field first and then order the rest
  45. Conditional operator OR not working with custom fields
  46. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  47. Should I reset $wp_query?
  48. WP ForLoop to compare meta information of posts to determine what post to display
  49. How to filter query loop block with a search string from the query parameters
  50. Query only displays one page_id
  51. Filtering by multiple conditions in the loop
  52. WP_User_Query orderby meta_val_num
  53. WP_Query custom order and pagination
  54. Sorting posts by Multiple custom fields in defined order
  55. I am officially missing something about transient posts
  56. WP_Query orderby random do not repeat infinite scroll – one loop
  57. Query multiple post types, but different order for each
  58. display ACF repater field in archive page
  59. Meta query orderby meta_value_num sorting by role first
  60. Order posts by tags count?
  61. Query against multiple locations within single custom post type post
  62. Problem with my loops
  63. How to get_comments() ordered by date and parent?
  64. Order 2 meta_queries differently in WP_Query?
  65. WP_Query & Duplicate entries
  66. WP Query. Ordering posts by another post types meta
  67. Query by meta value (add a dropdown of all values)
  68. How to order posts, that have already been filtered by custom taxonomy, by their category names?
  69. how to show more than 1 post into three columns query
  70. Display three sequential posts on each page load, without repeating previous
  71. orderby in WP_QUERY – Use the order from the Dashboard
  72. Ordering Posts by parent category, name ascending
  73. WP_Query secondary query failing
  74. Order Custom Field by Price
  75. WP_Query a custom field value bringing back 0 results
  76. Custom search (wp query by custom fields)
  77. How do I display posts with specific value in a custom field into my loop?
  78. query_posts with sorting on a custom datestamp
  79. Order by multiple meta keys on wordpress
  80. meta_query dates from an array
  81. Main loop querying current template’s info only in custom category archive pages, not my posts
  82. Get posts that were most recently tagged
  83. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  84. WP_Query sort by ACF date field (newest first) with blank dates first
  85. How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?
  86. Loop within a loop?
  87. Highlighting Sub topic in a post?
  88. how to retrieve specific product attribute value in an sql query?
  89. Setting get_queried_object
  90. Sort query by author: 1 author, then others
  91. Check return value of get_posts
  92. Get a list of posts by specific category
  93. WP_Query – Adding “offset” posts to the end of the loop
  94. Shortcode for custom query not returning results when attributes are added
  95. wp_query is showing posts from other categories
  96. ACF: How can I publish values of ACF fields in a loop while using wp_query?
  97. WP_Query random ordering not working since 5.4
  98. Paging works correctly on local version, but not live?
  99. Create global array to compare inside a query
  100. Custom post types loop on a page template