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

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

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

Answer: Option C