title: MYSQL: Like Method, Similar Words - But Don't Show the Searched Word
body: <p>actually i use this method to show similar words for a search request..</p>
  
  <pre><code>$query = "SELECT * FROM searches WHERE Query LIKE '%$search%' ORDER BY Query"; 
  </code></pre>
  
  <p>if someone searches for "nelly" it looks up in the database for similar words </p>
  
  <p>"nelly furtado, nelly ft. kelly"... </p>
  
  <p>but i dont want to show up the searched word..</p>
  
  <p>example: you've searched for nelly - try this too: <strong>nelly</strong>, nelly furtado, nelly ft., </p>
  
  <p>the bold word should not showed up again, because it's the searched word.. is there maybe a method with MATCH AGAINST? thank you!</p>