mysql - 如何从 mysql 表中获取随机行

Question

我的 Sql 查询是:

SELECT g.name, g.description, g.hash, g.views
FROM c7_groups g, c7_groups_affiliations ga, c7_groups_categories gc
WHERE ga.groups_hash = g.hash
AND ga.groups_categories_id = gc.id
AND g.groups_categories_id = 611<br/>
AND LOWER(ga.name) LIKE LOWER('%$school_name%')

我怎样才能让这个查询在每次触发时获取一些随机行。

谢谢泽尚

Answer 1

很简单，ORDER BY RAND():

SELECT g.name, g.description, g.hash, g.views FROM c7_groups g, c7_groups_affiliations ga, c7_groups_categories gc WHERE ga.groups_hash = g.hash AND ga.groups_categories_id = gc.id AND g.groups_categories_id = 611 AND LOWER(ga.name) LIKE LOWER('%$school_name%') ORDER BY RAND()

参见http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html有关性能提示