0

Hello

I Need To Know how to

Retrieve Random Data From A Table In Database

i have a table called actiongames

i need a code to retrieve random data from this table

2
Contributors
4
Replies
10
Views
5 Years
Discussion Span
Last Post by -==Zero==-
1

Zero, for something like this, you'll start learning MySQL Operators.

SELECT * FROM actiongames ORDER BY RAND()

If you want to designate how many rows to gather

SELECT * FROM actiongames ORDER BY RAND() Limit 5

Hope this helps!

Votes + Comments
Thanks Mate :)
0

Zero, for something like this, you'll start learning MySQL Operators.

SELECT * FROM actiongames ORDER BY RAND()

If you want to designate how many rows to gather

SELECT * FROM actiongames ORDER BY RAND() Limit 5

Hope this helps!

Ya It helps so much thanks so much

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.