title: UPDATE ORDER BY RAND() LIMIT 100
body: <p>I want to SET a text different for a field
  I am trying  that kind of code</p>
  <pre><code>SET  @rand = 100;
  UPDATE myTable SET  name = 'a'  ORDER BY RAND() LIMIT @rand;
  UPDATE myTable SET  name = 'b'  ORDER BY RAND() LIMIT @rand;
  UPDATE myTable SET  name = 'c'  ORDER BY RAND() LIMIT @rand;
  </code></pre>
  <p>I am getting an error</p>
  <blockquote>
  <h1>1221 - Incorrect usage of UPDATE and ORDER BY</h1>
  </blockquote>
  <p>thanks for helping</p>