SQL 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