Prev Next

MySQL RAND

The RAND function generates a random floating-point number between 0 and 1. It is useful for selecting random records or generating random values.

Examples with Tamil Kings

1. Generating a Random Number

SELECT RAND() AS random_number;

Code Explanation: This query generates a random floating-point number between 0 and 1.

2. Selecting Random Records

SELECT * FROM tamil_kings_auto_increment ORDER BY RAND() LIMIT 3;

Code Explanation: This query selects 3 random records from the tamil_kings_auto_increment table.

Best Practices

  • Use RAND() for generating random values or shuffling records.
  • Be cautious when using ORDER BY RAND() on large datasets, as it can be inefficient.

Key Takeaways

  • The RAND function generates a random number between 0 and 1.
  • It is useful for selecting random records or generating unique values.
Prev Next