title: How to select 1 random row from the latest 30 rows in MySql?
body: <p>I want to select one row from the latest 30 rows based on the date.
  And with the below it is selecting the random row from all the rows and thats not what I want.</p>
  <pre><code>SELECT * FROM product where userId=1 ORDER BY RAND() LIMIT 1
  </code></pre>
  <p>So how can I select from the latest 30? Thanks.</p>