title: Sql where clause not working
body: <p>SQL where clause is not working in my database. </p>
  
  <p>I have a table called "sites" and structure like that</p>
  
  <pre><code>id     site
  1      xyz.com
  2      google.com
  3      example.com
  </code></pre>
  
  <p>I am running this SQL query</p>
  
  <pre><code>SELECT * FROM `sites` WHERE `site` = "google.com";
  </code></pre>
  
  <p>But I am getting this output</p>
  
  <pre><code> MySQL returned an empty result set (i.e. zero rows). (Query took 0.0009 sec)
  </code></pre>
  
  <p>I never see before like that in my life.</p>
  
  <p>Update: Screenshot</p>
  
  <p>I do not want to apply this query in project.</p>
  
  <pre><code>SELECT * FROM `sites` WHERE `site` LIKE "%google.com%";
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/8SzcH.png" alt="Table"></p>
  
  <pre><code>#
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/HpyYn.png" alt="Query"></p>
  
  <hr>
  
  <p>The real problem was in <code>insert</code> commands on creation of DB.
  Try</p>
  
  <pre><code>INSERT INTO sites (id, site) VALUES (1, '\nxyz.com\n'), (2, '\ngoogle.com\n'), (3, '\nexample.com\n')
  </code></pre>
  
  <p>and manually check records in the table. You would not see line breaks. This is an issue in SQL I've noticed.</p>