title: MySQL get a random value between two values
body: <p>I have two columns in a row: <code>min_value</code>, <code>max_value</code>. Is there a way to do a select like:</p>
  
  <pre><code>SELECT RAND(`min_v`, `max_v`) `foo` [..]
  </code></pre>
  
  <p>I do realize that <code>RAND</code> does a different thing; the closest I came up (with help) is <code>(RAND() * (max-min))+min</code>, though it will produce a float number, which I'd need then to ROUND() and this is just completely wrong.</p>
  
  <p>Unless anyone can suggest an alternative (which would be very useful), I will go PHP way.</p>