Tag Archives: 随机

记录下mysql随机取数据的sql，效率高

SELECT
	*
FROM
	niceimg
WHERE
	id >= (
		(SELECT MAX(id) FROM niceimg) - (SELECT MIN(id) FROM niceimg)
	) * RAND() +[......]
Read more