Posted by Qun Cao on 11/07/16 11:31

Hi,

I have a question about sql query, I want to access a random entry in
table A. It should be a simple task, what I need is to first do
"select count(*) from A" to get the total, then generate a random
number N from the total count. The problem is, now I need to access
entry no.N of table A, yet A doesn't have a counting field; so I cannot
execute something like "select * from A where id = N". Does anybody
know how to access a certain entry from its' sequential order in the
table?

Thanks a lot!
qun

• Next in forum: Re: MySQL question- random entry
• Prev in forum: Re: Dynamic Voting Script
• Thread view: MySQL question- random entry

[Reply to this message]