title: How to randomly update a table?
body: <p>How can I update a table by attributing random values? I wish to randomize the column <code>isOnline</code> </p>
  
  <pre><code>id | name   | isOnline
  
  1 | johndoe | 1
  2 | janedoe | 1
  3 | marydoe | 0
  4 | teendoe | 0
  5 | babydow | 1
  </code></pre>
  
  <p><strong>Query</strong></p>
  
  <pre><code>UPDATE users
  SET isOnline = rand(int)
  WHERE isOnline='1' OR isOnline='0';
  </code></pre>