MySQL: Select Random Entry, but Weight Towards Certain Entries

by

This guy asks the same question. He says the same as Frank, but the weightings don’t come out right and in the comments someone suggests using ORDER BY -LOG(1.0 - RAND()) / Multiplier, which in my testing gave pretty much perfect results.

(If any mathematicians out there want to explain why this is correct, please enlighten me! But it works.)

The disadvantage would be that you couldn’t set the weighting to 0 to temporarily disable an option, as you would end up dividing by zero. But you could always filter it out with a WHERE Multiplier > 0.

More Related Contents:

  1. MySQL ORDER BY rand(), name ASC
  2. How can I properly use a PDO object for a parameterized SELECT query
  3. Notice: Array to string conversion in
  4. Selecting all columns that start with XXX using a wildcard?
  5. SELECT COUNT() vs mysql_num_rows();
  6. Select from mysql table WHERE field=’$array’?
  7. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  8. Algorithm for generating a random number
  9. How do I set the selected item in a drop down box
  10. Selecting all fields except only one field in mysql [duplicate]
  11. select within 20 kilometers based on latitude/longitude
  12. How to get the value which user has selected in php?
  13. for loop is not executed /getting error like loop is not working
  14. Organization db for blog posts with Mysql and Php [closed]
  15. PHP – Change value y,n in database [closed]
  16. I can’t view the database content on a php page [closed]
  17. mysqli or PDO – what are the pros and cons? [closed]
  18. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  19. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  20. Cannot connect to MySQL 4.1+ using old authentication
  21. PHP Commands Out of Sync error
  22. MySQL/PHP Error:[2002] Only one usage of each socket address (protocol/network address/port) is normally permitted
  23. how to check and set max_allowed_packet mysql variable [duplicate]
  24. PHP: multiple SQL queries in one mysql_query statement
  25. What’s the disadvantage of mt_rand?
  26. MySql Error: 1364 Field ‘display_name’ doesn’t have default value
  27. Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted
  28. PDOException “could not find driver” in php
  29. How to convert MySQL time to UNIX timestamp using PHP?
  30. Insert non-English decimal points in mysql

Leave a Comment