[mysql] random row 가져오기

 

SELECT F_DESC FROM TB_DETAIL_FOOTER WHERE USE_YN = 'Y' ORDER BY RAND();

 

결과 갯수 설정

SELECT F_DESC FROM TB_DETAIL_FOOTER WHERE USE_YN = 'Y' ORDER BY RAND() LIMIT 1;