Question

Sonal needs to display name of teachers, who have "o" as the third character in their name. She wrote the following query.

Select name
From teacher
Where name ="$$o?";

But the query is not producing the result. Identify the problems.

Answer 1

Problems:

• = cannot perform pattern matching; use LIKE.
• SQL wildcards are % and _, not $$ and ?.
• For o as the third character, use two underscores before o, followed by %.

SELECT name
FROM teacher
WHERE name LIKE '__o%';