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

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

Answer: Option C