mysql怎么随机获取数据库里信息

时间：2015-04-02 10:52:58 　来源：免费模板网　作者：风雪　阅读次数　tags随机函数

mysql怎么要获取随机阅读，在php里面有rand()函数，那么在mysql里面有没呢？那么请看下文
在php里面的函数跟msql不一样，在php里面rand(1,10)但是在mysql里面就不是这样了

mysql如何随机抽取数据库里的几条数据呢?读取随机数只要使用RAND就可以了,方法非常的简单,下面我来给各位举个例子.

数据库连接这些就不贴代码了,直接粘贴sql语句,代码如下:

SELECT `title` , `id`

FROM news

ORDER BY RAND( )

LIMIT 0 , 5;

随机从new表里取出5条数据,显示id和标题,代码如下:

mysql> select username from cdb_members order by rand() limit 0,5;

+-----------+

| username  |

+-----------+

| Takeshi   |

| icelong   |

| 狗狗请罪  |

| 菜头      |

| weike1130 |

+-----------+

5 rows in set (0.01 sec)

1、

SELECT * FROM `table` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`))+(SELECT MIN(id) FROM `table`)) AS id) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 1;

2、

SELECT * FROM `table`  WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`)) + (SELECT MIN(id) FROM `table`)))   ORDER BY id LIMIT 1;