jonpemby/random_string_from_list.sql

Last active March 7, 2018 16:19

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jonpemby/a2da452914e7968aebaea8cb60d52939.js"></script>
Save jonpemby/a2da452914e7968aebaea8cb60d52939 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL random string from list

Raw

random_string_from_list.sql

select elt(floor(1 + (rand() * @len)), "hello", "world", "this", "is", "a", "random", "list");

jonpemby commented Mar 7, 2018

Author

Edit

Fixed a NULL popping up - forgot to use FLOOR to keep random index within bounds

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment