title: How to select words of the same CHAR_LENGTH in MySQL-PHP?
body: <p>In order to use in a multiple choice test on Chinese Language, I need to select 5 words, all of them must have the same number of characters, one for the question, four for options. What I have been doing is:</p>
  
  <pre><code>SELECT hanzi, CHAR_LENGTH(hanzi) chlen FROM wordlist ORDER BY RAND() LIMIT 1
  </code></pre>
  
  <p>From here I get chlen to use it in another statement:</p>
  
  <pre><code>SELECT hanzi FROM wordlist WHERE CHAR_LENGTH(hanzi)=$chlen ORDER BY RAND() LIMIT 4
  </code></pre>
  
  <p>Can I do this using only one statement?</p>