$wpdb->get_col and ORDER BY?

You don’t want ORDER BY $wpdb->postmeta.post_id rand(). If you had debugging enabled, you’d see an error. You need to separate ORDER BY values with a comma– ORDER BY $wpdb->postmeta.post_id, rand(). In your case, that won’t do any good because the first value gets precedence, so the query will order by the ID and then randomize “within” that first level order… but there is not “within” in this case.

Just use ORDER BY rand()

Related Posts:

  1. Custom post type – order field
  2. Order by & include array by specific post ids
  3. Sort Order for a Custom Query in a Post Type Archive Not Working
  4. Select All in Parent Category, Group by Child Category?
  5. Get terms that contain posts that in turn belong to other terms?
  6. Ordering posts having multiple post-meta date fields
  7. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  8. Custom Post type sort order not working in the admin area
  9. Order posts by (hierarchical custom) taxonomy terms and term children
  10. Compare 3 custom fields and sort by oldest
  11. List upcoming events, ordered by date in a custom field
  12. WP_Query post at custom position
  13. Sort custom post types by last name in the backend
  14. Want to filter only parent post in admin area
  15. $wpdb returns no results with SELECT query on custom post type, works on default post type
  16. WooCommerce – Show orders for a specific product ? [closed]
  17. Inserting data into `post meta` table?
  18. Re-order posts in query after
  19. using custom taxonomies on non wp table?
  20. Display custom post types with custom date field value (before today) & order by custom date field
  21. Custom Post Type order by modified date and custom meta field issue
  22. How to query different post types in specific order?
  23. How to quickly reorder posts in the admin panel that will persist for the wp-api
  24. Custom Post Type + 20k posts = blank/404 within Admin edit.php [duplicate]
  25. wpdb custom post_type problem
  26. How do I make a custom taxonomy for a CPT appear inbetween title and editor boxes?
  27. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  28. Combining sorted and random CPT
  29. Show listings from Impress Listing plugin in random order using taxonomy and terms
  30. Insert post metadata for all posts in CPT at once if metadata no existent
  31. Rewrite and custom post type: order by custom field not working
  32. Convert simple SQL Query to WordPress query
  33. Add meta value to custom post type on publish
  34. Previous/Next Link by Meta Value in CPT
  35. using $wpdb to get custom post type with term
  36. How to order separated Custom Post Search results
  37. Wp_query: sort by PHP variable
  38. Allow user to set custom order to a list of custom taxonomies?
  39. Converting the_content string to an array?
  40. Display custom fields from custom posts in RSS feed
  41. Sort CPT archive by order prevents sorting in admin
  42. How to do WP_Query with two meta fields with orderby clause
  43. Order Custom Post Type by Custom Field Value
  44. Get terms that contain posts that in turn belong to other terms?
  45. Get the taxonomy of a post hierarchically
  46. Change sort order when using ‘orderby’ => ‘type’
  47. Display Woocommerce Orders for specific author [closed]
  48. Ordering custom post type by multiple custom fields
  49. Order by custom field meta_key date and then by custom file meta_key number
  50. Save custom post type to external database
  51. 4 column-loop ordered alphabetically with entries grouped (and labeled) by their first letter
  52. Ascending Order is not Working in Custom Post Type Listining
  53. WPDB for post count on post
  54. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  55. WP_Query of custom post type sorted by meta_key has unexpected results
  56. WP_Query not resetting after wp_reset_postdata
  57. Post ordering not working with custom field
  58. Filtered by a custom field, ordered by another
  59. orderby parameter not working in custom query
  60. foreach loop inside the loop creating duplicates in output
  61. $wpdb is queried but results don’t show
  62. show most viewed posts of last days by link?
  63. Changing WordPress sort order for returned child pages
  64. Display Parent-Child Posts in specific order by comparing IDs in array
  65. How can I sort the results of a REST API response by the title of a connected custom post type?
  66. Order posts alphabetically with numbers but some of the posts has numbers in the title
  67. Filter in Custom post type to find the parent post
  68. How to order taxonomy terms by most recent post?
  69. Orderby if between two meta fields
  70. Display custom posts, ordered by most commented, without duplicates
  71. Custom post type order by post_title
  72. SEARCH QUERIES – REVERSE OUTPUT
  73. How to order multiple custom post types with same taxonomy by date
  74. How to store additional data that is related to core data
  75. Using Orderby and meta_value to order natural/alphanumerical
  76. Update 2 wordpress tables at once
  77. What’s the most efficient way to get two queries based on an if statement?
  78. WP Query with multiple post types ordered by custom meta date then published date
  79. Orderby modified only for specific post types
  80. Custom post order when using OR relation
  81. Help ordering custom query by Title, Ascending
  82. Custom Post save causes 500 error
  83. shortcode order for event custom post type
  84. How to display custom post type ordered by a custom field date
  85. Order Custom Posts by Several Fields
  86. Query Distinct Taxonomies of Custom Post Type
  87. show previous/next post orderer by title in custom post types
  88. Ordering custom post type by custom field without a title
  89. Adapting plugin for custom post type?
  90. Create custom post order (with custom post type meta)
  91. Retrieve post data via WPDB class
  92. $wpdb returns no results with SELECT query on custom post type, works on default post type
  93. 404 on Pages for Custom Post Type & Query_Posts
  94. Trying to display posts by authors in with specific user meta
  95. Posts 2 Posts: query connected — orderby problem
  96. Order custom post type is beign ignored
  97. How to order different custom post type in category or tag template page?
  98. WP_query orderby not working after WP4.0 update [closed]
  99. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  100. Query order by meta value force specific tag first
tech