title: MySQL InnoDB Full Text Search: searching for email
body: <p>We are using the InnoDB FTS functionality introduced in v5.6, and are having problems constructing the search to effectively find email addresses.</p>
  
  <p>The @ symbol is disallowed (it will throw an error), and the '.' seems to throw things off. For example:</p>
  
  <p>for: user@email.com</p>
  
  <p>this yields an error because of the @ symbol:</p>
  
  <pre><code>SELECT * FROM table WHERE MATCH (email) AGAINST ('+user@email.com*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>this returns no results because of the period:</p>
  
  <pre><code>SELECT * FROM table WHERE MATCH (email) AGAINST ('+user* +email.com*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>this returns a result, but is not as complete as desired:</p>
  
  <pre><code>SELECT * FROM table WHERE MATCH (email) AGAINST ('+user* +email*' IN BOOLEAN MODE)
  </code></pre>
  
  <p>Can anyone provide insight and suggestions for ways to improve an FTS search when using email addresses as the search term?</p>