B4J Question Retrieval from MySQL database with a Random requirement

[Peter Lewis]

Hi All,

I have not attempted to do this line of code yet as I am not a Wizz at SQL or B4J so I was hoping someone could give me a starting point or a direction I should be going in or even if this is possible.

I do not want to retrieve all the results and then randomise between those, that would be easier but would take time to remotely retrieve the database.

There are 3 fields that are used to retrieve the filtered records.

1. Catagory
2 Sub Catagory (if any)
3. Difficulty

I think I should add an index with the 3 fields above into MySQL

From the results set I want to randomly choose x amount of ID's where x is a number of questions

Thank you in advance

Peter

 

[Erel]

Check this answer: https://stackoverflow.com/a/12870681/971547
I haven't tried it myself however it is very simple and it will probably be fast enough.

 

[Peter Lewis]

Check this answer: https://stackoverflow.com/a/12870681/971547
I haven't tried it myself however it is very simple and it will probably be fast enough.

Thank you Master

 

[KMatle]

Another one: Usually you add an unique ID (autoincrement). So each entry in a table is addressable exactly. Example: A customer ID. So if you have 1500 questions and the ID is an integer just generate e.g. 10 integer values between 1 and 1500 and do a select with it.

 

[Peter Lewis]

Another one: Usually you add an unique ID (autoincrement). So each entry in a table is addressable exactly. Example: A customer ID. So if you have 1500 questions and the ID is an integer just generate e.g. 10 integer values between 1 and 1500 and do a select with it.

That will not work as if there are 1500 questions in the database , only 300 will match the search criteria so the random must be in the result set of 300 and not in the total records