从SQL表中选择2个随机行

What would be the fastest way to select 2 random rows from an SQL table ? (SQL only or not) I am using MySQL on PhpMyAdmin.

Seems like it would be:

SELECT * FROM table LIMIT 2

What you will get is two rows in database default order.

Try this:

SELECT * FROM table ORDER BY RAND() LIMIT 0, 2