title: Trouble in logic with mysql
body: <p>I have an online shop of watches. It has a search filter. One criterium of filtering is the material of body of watches. There are lots of unique values of it. For instance: "steel", "steel with gold", "steel with gold plating". </p>
  
  <p>I tried to filter watches by creating an sql LIKE request to filter watches with steel body, gold body. But when searching for watches with golden body it also gives me steel watches with gold plating because it consists the word "gold". </p>
  
  <p>Can you suggest a good solution to solve this problem?</p>
  
  <p>So far I tried this sql statement:</p>
  
  <pre><code>SELECT * FROM `watches` WHERE `material` LIKE "%gold%"
  </code></pre>