title: SQL "=" doesn't work on string while "LIKE" does.
body: <p>I am doing a simple data pull on a table with the below "WHERE" condition</p>
  
  <pre><code>SELECT * FROM table1
  WHERE name = 'Amy' OR name = 'John'
  </code></pre>
  
  <p>There are no "johns" in the existing table currently so I expect the result to return only data with "Amy" (Amy is spelled the exact way in the DB). However, result did not return anything. However, when I enter the query as:</p>
  
  <pre><code>SELECT * FROM table1
  WHERE name LIKE 'Amy' OR name LIKE 'John'
  </code></pre>
  
  <p>That returns my result as expected with only Amy's data in there. I understand the difference between '=' and 'LIKE', but why wouldn't using '=' in the first case return any results?</p>