title: Find a word within Text in mysql
body: <p>Before posting I've searched a lot but I've not found what exactly I was searching for. The question is quite simple.</p>
  
  <p>I've a text in a table (database <strong>MySql</strong>) which has to use <strong>InnoDB engine</strong> (so I can't use <a href="http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html" rel="nofollow">FULL-TEXT search</a> which requires MyIsam as engine). My goal is to <strong>find a word in the text</strong>. The word, as you can easily guess, can be surrounded by space, tabs, marks and so on and can be at the start, in the middle or at the end of this text.</p>
  
  <p>I know that I can use <a href="http://dev.mysql.com/doc/refman/5.1/en/regexp.html" rel="nofollow">REGEXP</a> operator and infact I use it but the SQL statement that I made it's not exactly what I need and so I thought to post the question. This is my actual SQL:</p>
  
  <pre><code>SELECT *
  FROM table
  WHERE field REGEXP '[[:space:][:graph:]]+THEWORD[[:space:][:graph:]]+'
  </code></pre>
  
  <p>How I can achieve my goal?</p>
  
  <p>Thanks to everyone.</p>