title: Update column with random value
body: <p>I have a table:</p>
  
  <pre><code>ID | VALUE | DATE
  1  | 5     | 2012-10-01 
  2  | 7     | 2012-10-02
  3  | 3     | 2012-10-05
  4  | 0     | 2012-05-07 
  </code></pre>
  
  <p>I want to add on <strong>the top of the current value</strong> with the VALUE random <strong>individually</strong> BETWEEN 1 AND 5. </p>
  
  <p>Let say:</p>
  
  <pre><code>ID | VALUE | RANDOM VALUE
  1  | 5     | 0
  2  | 7     | 2
  3  | 3     | 3
  4  | 0     | 6 
  </code></pre>
  
  <p>NEW VALUE</p>
  
  <pre><code>ID | VALUE 
  1  | 5     
  2  | 9     
  3  | 6     
  4  | 6      
  </code></pre>
  
  <p>How do I do this? All I can think of is by doing cursor type of query.</p>
  
  <p>Any help?</p>