Which clause is used to display information that matches a given pattern?

Solution (By Examveda Team)

This question asks about how to find specific data in a database. Think of it like searching for a book in a library.

We need a way to tell the database exactly what we're looking for.

Of the choices given:

Option A: WHERE is used to filter data based on specific conditions. It's like saying, "Give me only the books written by Jane Austen".

Option B: IS checks if a value is equal to something. It's like saying, "Is this book fiction?"

Option C: SAME is not a valid keyword in MySQL.

Option D: LIKE is the answer! It allows us to search for data that matches a specific pattern. This is like saying, "Give me all the books with the word 'mystery' in the title."

So, the correct answer is Option D: LIKE.