order by in mysql for order some random id code example

Example: SQL order random

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