title: Count occurrences of character in a string using MySQL
body: <p>Example Words: a, akkka, akokaa, kokoko, kakao, oooaooa, kkako, kakaoa</p>
  
  <p>I need the regexp witch gives words with 2 or less 'a' but not the words without 'a'</p>
  
  <p>Result: a, akka, kakao, oooaooa, kkako</p>
  
  <p>Ok actually I am using:</p>
  
  <pre><code>SELECT word FROM dictionary_gr WHERE word REGEXP 'λ{2,3}' LIMIT 0 , 30
  </code></pre>
  
  <p>this returns 0 lines there are words with 2 λ's and 3 λ's </p>