select random rows mysql code example

Example 1: SQL order random

SELECT FIELD_NAME FROM TABLE_NAME ORDER BY RAND() LIMIT 1
/* NOTE if this doesnt work try random() */

Example 2: mysql select random id from table

-- randomly order, select first 5 rows
select * from `table_name` order by rand() limit 5

Example 3: generate random & unique mysql string

DO 
    SELECT LEFT(UUID(), 8) INTO @var;
    INSERT INTO col (@var);
WHILE there_is_a_unique_constraint_violation

Tags:

Sql Example

Related