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

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

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

Answer: Option C