JeopardyDatabase: Difference between revisions
Content added Content deleted
imported>Adamf |
imported>Adamf |
||
Line 224: | 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: |
<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> |
<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. |
You can also use <code>ORDER BY</code> to sort the clues by value. |
||
Line 244: | Line 244: | ||
</li> |
</li> |
||
</ul> |
</ul> |
||
=== 2. Random game categories === |
=== 2. Random game categories === |