title: Search string by exact word in Mysql
body: <p>I have a system that searches for company. I want that when a user searches for "Demo", all records that have "Demo" will be returned, like "The Demo", "Demo Inc.", etc. I don't want those records like "Democratic", "Demolition", etc. I think you get my point.</p>
  
  <p>Right now, my working query looks something like this:</p>
  
  <pre><code>select * from table where company LIKE "Demo%"
  </code></pre>
  
  <p>But that really doesn't hit my requirement. I also tried this one:</p>
  
  <pre><code>select * from table where company RLIKE "[[:&lt;:]]demo[[:&gt;:]]"
  </code></pre>
  
  <p>The only problem on that one is that it eliminates the possibility of index on my company field. So it searches really slow. I have over a million records right now. Any idea how to do it? If it can't be done in mysql, any idea if it's possible in PHP? Thanks!   </p>