title: creating a random number using MYSQL
body: <p>I would like to know is there a way to select randomly generated number between 100 and 500 along with a select query. </p>
  
  <p>Eg: <code>SELECT name, address, random_number FROM users</code></p>
  
  <p>I dont have to store this number in db and only to use it to display purpose. </p>
  
  <p>I tried it something like this, but it can't get to work..</p>
  
  <pre><code>SELECT name, address, FLOOR(RAND() * 500) AS random_number FROM users
  </code></pre>
  
  <p>Hope someone help me out.
  Thank you</p>