title: Query for exact match of a string in SQL
body: <p>I want to query for the exact match of a string from a database table. </p>
  
  <p>When I write the query as</p>
  
  <pre><code>select description from tproduct where description like '%diamond%'
  </code></pre>
  
  <p>it runs and gives the results as a <code>wild card</code> query. For example, I got ringdiamond, diamondmaster, etc.</p>
  
  <p>But I want to get only "diamond".</p>
  
  <p>For this I did as:</p>
  
  <pre><code>select description from tproduct where description = 'diamond'
  </code></pre>
  
  <p>But it is giving an error:</p>
  
  <blockquote>
    <p>Error: Unknown column 'diamond' in 'where clause'</p>
  </blockquote>
  
  <p>The description column contains:</p>
  
  <pre><code>This bracelet is composed of round diamond surrounded by milgrain detailing. Its secure setting prevents it from twisting and ensures it will sit impeccably on her wrist.
  
  
  This stylish design is the perfect accessory for the day or evening. Akoya cultured pearls are lined up by a string of bezel-set round diamond.
  </code></pre>