ReferenceSQL FunctionsNumeric FunctionsRANDOMOn this pageRANDOMrandomβ descriptionβ Syntaxβ DOUBLE random() Returns a random number between 0-1. exampleβ mysql> select random();+---------------------+| random() |+---------------------+| 0.35446706030596947 |+---------------------+ keywordsβ RANDOM