Skip to content

Instantly share code, notes, and snippets.

@apphp

apphp/mysql-get-random-record-based-on-weight

Created June 11, 2017 19:09
Show Gist options
  • Save apphp/62f46e52a0a3e566271726bc8fd336c6 to your computer and use it in GitHub Desktop.
Save apphp/62f46e52a0a3e566271726bc8fd336c6 to your computer and use it in GitHub Desktop.
Download ZIP
Get Random Record Based on Weight
Raw
mysql-get-random-record-based-on-weight
-- http://www.apphp.com/index.php?snippet=mysql-get-random-record-based-on-weight
-- Must have as field named 'weight'
SELECT * FROM `table` ORDER BY RAND() * (1 / `weight`)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment