title: MySQL random string longer than 32 characters
body: <p>I am trying to generate a 36 character random string in MySQL using:</p>
  
  <pre><code>UPDATE my_table SET entity_uid = substring(MD5(RAND()) FROM 1 FOR 36);
  </code></pre>
  
  <p>but the result is always a 32 character string. Is there a way to get a longer string?</p>