title: SQL SELECT query not working with Email Addresses
body: <p>I am trying to query an e-mail address stored in my database for log-in. I am having issues with the query in PHP, when I attempted the query with SQL in PHPMyAdmin it returns an empty set. After doing some testing I determined the following for an email of something@gmail.com:</p>
  
  <p>Works:</p>
  
  <pre><code>SELECT * FROM `Careers` WHERE `Email` LIKE '%something%' and
  
  SELECT * FROM `Careers` WHERE `Email` LIKE '%gmail.com%' and
  
  SELECT * FROM `Careers` WHERE `Email` LIKE '%@%'.
  </code></pre>
  
  <p>Doesn't work:</p>
  
  <pre><code>SELECT * FROM `Careers` WHERE `Email` LIKE 'something@gmail.com' and
  
  SELECT * FROM `Careers` WHERE `Email` LIKE '%something@gmail.com%' and
  
  SELECT * FROM `Careers` WHERE `Email` LIKE '%@gmail.com%'
  
  SELECT * FROM `Careers` WHERE `Email` LIKE '%something%gmail.com'
  </code></pre>
  
  <p>I'm completely lost as to how to correct this. The only think I can think of is it is an issue with the @ sign as when I add the @ sign the query seems to fail. Any help you could provide would be greatly appreciated!</p>