Random Select

[R4v]

Hi all,

What would be the best way to select 2 random rows from the last 10 in a table.

For example, I only want to show 2 news headlines, but I want them to be randomly selected from the last 10 entries.

The table has a ID (auto inc) and a date field.

Any ideas would be great.

[NogDog]

Maybe...

SELECT * FROM table_name
WHERE id > (SELECT id - 10 FROM table_name ORDER BY id DESC LIMIT 1)
ORDER BY RAND() LIMIT 2

[R4v]

That worked like a charm, many thanks NogDog 🙂