How to Order by random on a SQL query

You can use ORDER BY rand(), but it’s a very heavy query as a temporary table is created for it.

A WC_Product_Query or a WP_Query could be a good alternative to WPDB custom query. Both support 'orderby' => 'rand',…

Related Posts:

  1. Get WooCommerce product attribute taxonomies in a SQL query on WordPress database
  2. How to get all products from an order including variations via SQL query?
  3. get woocommerce product image url and price from database [closed]
  4. Update WooCommerce stock status with SQL query if stock value is greater than 0
  5. How to get products without tag?
  6. Woocommerce change the price of products in the database
  7. Query product’s image path by category WooCommerce database?
  8. How to speed up “My Account > Orders Page” on Site with More than 200,000 orders?
  9. Alter the cost of products using phpmyadmin sql query
  10. Woocommerce order_complete email dont send after changing order status via sql
  11. Use a woocommerce hook to create a table and populate it with a query
  12. Is it possible to extract all product columns except for one?
  13. How to address an invalid “NOT IN ()” query?
  14. Woocommerce – Add a product to cart programmatically via JS or PHP [closed]
  15. ( Woocommerce) How to get the user belonging to an order? [closed]
  16. Get the product list of a given Category ID
  17. List of JS events in the WooCommerce frontend
  18. get woocommerce My account page link
  19. WooCommerce: How to edit the get_price_html
  20. Get woocommerce product price by id [closed]
  21. Product categories don’t appear as option to build menu
  22. WooCommerce Variable Product Price not showing on single product page
  23. How to override WooCommerce template files?
  24. Woocommerce add extra field to variation product
  25. Getting the gallery images from products in woocommerce?
  26. How to get current product category ID in product archive page
  27. Get url of product’s images (woocommerce)
  28. WooCommerce prices location in DB
  29. Order by rating not works in wp_query
  30. Woocommerce: How to remove page-title at the home/shop page but not category pages
  31. Woocommerce show cross sells on singe product page [closed]
  32. How to add a new endpoint in woocommerce
  33. Are there any hook or filter when refund is done through admin -woocommerce
  34. How to check if is in cart page? [closed]
  35. Display single product attribute value on Shop page (Woocommerce)
  36. WP/WooCommerce REST API cart/checkout/order [closed]
  37. how to use wc_create_order with subscription product
  38. WooCommerce: Webhook disabled on its own
  39. Share users and WooCommerce memberships between two installations
  40. Slow Loading Attribute Select – WooCommerce Backend
  41. WooCommerce: Can’t use wc_get_products for custom REST API endpoints
  42. How to change or add Woocommerce thank you page URL key content?
  43. How can I define a custom template for woocommerce [products] shortcode? [closed]
  44. How to remove an action within a class with extends
  45. single-product.php template not working for single products [closed]
  46. Insert variations via woocommerce api [closed]
  47. WooCommerce get physical store address
  48. Is it possible to add custom fields to a WooCommerce attribute term? [closed]
  49. wc_get_template_part( ‘content’, ‘product’ ) | Where is this file located?
  50. how to get woocommerce product attribute slug
  51. Correct function to get the user’s latest Woocommerce Subscription?
  52. Move payment options at checkout in WooCommerce [closed]
  53. add_filter to modify woocommerce_cart_item_name hyperlink
  54. Where do the cart details are stored in database?
  55. How to display product price of the product in loop
  56. How to disable Woocommerce password recovery and use the default WordPress password reset page?
  57. Display order items names in WooCommerce admin orders list [closed]
  58. Is it safe to delete from db orphaned posts i.e. whose post_parent no longer exists?
  59. Add custom variable to cart content [closed]
  60. Get product details by url key in WordPress woocommerce
  61. Get product link
  62. WooCommerce – Hook after Loading Variation in Admin Edit page?
  63. How to delete woo commerce order pragmatically? [closed]
  64. WooCommerce changes lost password reset link
  65. Process checkout using WC REST API
  66. How to get rid of the hover zoom in WooCommerce single products
  67. How do I display certain products via their category on a section of a page using PHP?
  68. How to turn off WooCommerce user registration and manually create accounts?
  69. What’s the difference between WC() and $woocommerce
  70. Display orders instead of woocommerce my account dashboard for logged in users [closed]
  71. Limit users to one active subscription in WooCommerce Subscriptions? [closed]
  72. Detect whether a page is a product subcategory page?
  73. Hidden woocommerce products still showing up in search results [closed]
  74. Menu not show woocommerce product category
  75. Orders being sent to wrong admin email in WooCommerce [closed]
  76. WooCommerce: add different order item meta for each item in order
  77. Remember page before login page, redirect to that page after login
  78. Woocommerce 3.1 Add product image to order confirmation email not working
  79. Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
  80. Woocommerce My Account Endpoint – how to get ID parameter from URL?
  81. Hook and send Woocommerce data after click Place Order button
  82. Woo-commerce | Disable proceed to checkout button in cart page if total in cart less than 15 [closed]
  83. Fatal Error when installing woocommerce despite upgrading
  84. Adding an action within a function that is being called by add_filter
  85. WooCommerce conditional meta query
  86. Default woocommerce placeholder image
  87. How to build a plugin that supports authenticated POST requests to the REST API from external servers?
  88. Hide certain tags on Product Edit tag cloud
  89. Updating WooCommerce variable product stock issue
  90. WooCommerce: Add New Report Tab
  91. WooCommerce Change Product Global Attribute Value via CRUD for Simple Product [closed]
  92. How to get values from woocommerce admin input fields?
  93. Show only geolocated user country into Woocommerce checkout country fields
  94. Search results don’t show products
  95. Optimizing Woocommerce order items query
  96. What is the right hook to use in WooCommerce for handling the post of the sale price?
  97. Add a custom button with custom link after add to cart for every product
  98. How to add Woocomrce cart page shipping calculator to my country state list
  99. When Free shipping is available hide other shipping methods except Local pickup in WooCommerce [closed]
  100. Programmatically change Payment Methods WooCommerce
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)