Anonymous user
JeopardyDatabase: Difference between revisions
→1. Random category clues
imported>Adamf |
imported>Adamf |
||
Line 224:
<b>tip</b>: SQL supports an "<code>ORDER BY RANDOM()</code>" clause that will return rows in a random order. For example, to randomly pick 1 category id you could use:
<pre>SELECT id FROM category ORDER BY RANDOM() LIMIT 1;</pre>
You can also use <code>ORDER BY</code> to sort the clues by value.
Line 244:
</li>
</ul>
=== 2. Random game categories ===
| |||