title: REGEXP in mysql
body: <p>I have a database of all english language words. I want to find regular expression for particular alphabets. like for example if i ask for the regular expression for "eta", it should return all the words who have 'e','a' and 't' in any combination. but when I run the following code </p>
  
  <pre><code>SELECT word FROM wordlist
  WHERE 
  word REGEXP 'eta';
  </code></pre>
  
  <p>it return words like 'beta,caretake,detach etc....'<br>
  how to use regexp in its true spirit in mysql.
  Thanks in Advance </p>