Like

use if you want to match a string against your query

  • ex. return all emails that have @gmail (Private) in them ...WHERE email LIKE '%gmail.com'