sql get random row 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: sql pick random row
SELECT column FROM table
ORDER BY RAND()
LIMIT 1
Example 3: t-sql random number for each row
ABS(CHECKSUM(NewId())) % 14