In SQL, which of the following syntax is correct for the where like?

  • A. SELECT * FROM tblcustomer WHERE name = ‘%sok%’
  • B. SELECT * FROM tblcustomer WHERE name == ‘%sok%’
  • C. SELECT * FROM tblcustomer WHERE name LIKE ‘%sok%’
  • D. None correct

Answer: Option C