title: MySQL insert random values from another table
body: <p>Hi I want to inserting some random values from one table to another my query looks like that:</p>
  
  <pre><code>INSERT INTO `rounds`(`matchID`, `questionOneID`, `questionTwoID`, `questionThreeID`) VALUES (17,(SELECT `id` FROM `questions` ORDER BY RAND() LIMIT 3))
  </code></pre>
  
  <p>The problem is, that mysql wants 4 parameter (matchID, questionOneID,...) and only gets two (17,(...)) how do I tell MySql that it gets 3 parameters from the SELECT?
  Did i really have to: </p>
  
  <pre><code>INSERT INTO `rounds`(`matchID`, `questionOneID`, `questionTwoID`, `questionThreeID`) VALUES (17,(SELECT `id` FROM `questions` ORDER BY RAND() LIMIT 1),(SELECT `id` FROM `questions` ORDER BY RAND() LIMIT 1),(SELECT `id` FROM `questions` ORDER BY RAND() LIMIT 1))
  </code></pre>
  
  <p>or is there a better way?</p>