title: Select (keyword) from table phpmyadmin using LIKE
body: <p>Following on from my last question: </p>
  
  <p>I am now using the statement: </p>
  
  <pre><code>    if (isset($_GET['url'])) {
          $url = $_GET['url'];
      }
  
  
        SELECT name, url FROM table WHERE species LIKE '%$url%'
  </code></pre>
  
  <p><code>species</code> could have content likes <code>"Brown &amp; Rainbow Trout, Pike"</code></p>
  
  <p>however my url for say Brown Trout is : <code>/fishing/browntrout/</code></p>
  
  <p>This basically prevents the statement above from returning any results.</p>
  
  <p>Clearly it works fine for say : <code>/fishing/pike/</code> just not for the fish that have 2 names.</p>
  
  <p>Whats the best way to resolve this?</p>