title: MYSQL Select where string contains keywords
body: <p>So, I've been doing some digging but I can't really find something specific. Let's say I have a table called <code>products</code> with 2 columns: <code>product_name</code> and <code>vendor</code>.</p>
  
  <pre><code>product_name  |  vendor
  Item A        | Computer Mania
  Item B        | Incredible Connection
  Item C        | Computer Mania
  </code></pre>
  
  <p>So, now let's say hypothetically I don't remember how to spell <code>computer</code> and I say, okay I remember the name starts with <code>co</code> and ends with <code>er</code> and there is <code>mania</code> afterwards.</p>
  
  <p>How can I build a SELECT query with those conditions in my WHERE? I have no idea how to do it.</p>
  
  <p>Here's what I tried:
  <code>SELECT * FROM products WHERE vendor_name LIKE '%co%';</code> </p>
  
  <p>However this returns <code>Incredible Connection</code> as well, which I don't want.</p>