The following query selects details of all those employees whose name consists of exactly 5 letters and starts

Worked Examples · Example 9.15

Q. The following query selects details of all those employees whose name consists of exactly 5 letters and starts with any letter but has 'ANYA' after that.

Puducherry TnboardTextbookSubjective· 2mImportance★★★★★

31% · 29/95 Questions

🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

"Exactly 5 letters, starting with any letter, with 'ANYA' after that" collapses to one pattern: '_ANYA'. On the real EMPLOYEE table this matches Sanya and Tanya.

The condition means the name is of the form ?ANYA, where ? is any single letter — so the name is 5 letters long and its last four letters are fixed as 'ANYA'. The _ wildcard in LIKE matches exactly one arbitrary character, which is exactly what's needed for the first position:

SELECT * FROM EMPLOYEE WHERE Ename LIKE '_ANYA';

On the real EMPLOYEE table (Table 9.8), the ten names are Aaliya, Kritika, Shabbir, Gurpreet, Joseph, Sanya, Vergese, Nachaobi, Daribha, Tanya. Only Sanya and Tanya are exactly 5 letters and end in 'ANYA'. …

Start your 14-day free trial to unlock the full solution →

Example 9.15, on the real EMPLOYEE table (Table 9.8): the pattern '_ANYA' — one arbitrary character followed by the literal 'ANYA' — matches exactly two names, Sanya and Tanya.

The real EMPLOYEE table (Table 9.8)

EmpNo	Ename	Salary	Bonus	DeptId
101	Aaliya	10000	234	D02
102	Kritika	60000	123	D01
103	Shabbir	45000	566	D01
104	Gurpreet	19000	565	D04
105	Joseph	34000	875	D03
106	Sanya	48000	695	D02
107	Vergese	15000	NULL	D01
108	Nachaobi	29000	NULL	D05
109	Daribha	42000	NULL	D04
110	Tanya	50000	467	D05

The requirement is: exactly 5 letters, first letter can be anything, and the last four letters must be 'ANYA'. The pattern '_ANYA' does exactly this — _ matches exactly one character, and ANYA matches the literal suffix.

mysql> SELECT * FROM EMPLOYEE
    -> WHERE Ename like '_ANYA';

Checking every real name: only Sanya and Tanya are 5 letters long and end in 'ANYA'. (Kritika is 7 letters and doesn't end in ANYA; none of the others do either.)

Output …

Start your 14-day free trial to unlock the full solution →

←Previous question · 9.6.2Example 9.14 — The following query selects details of all those employees whose name …→Next question · 9.6.2Example 9.16 — The following query selects names of all employees containing 'se' as …

Q.The following query selects details of all those employees whose name consists of exactly 5 letters and starts with any letter but has 'ANYA' after that.

Concept understanding — Set Difference

The real EMPLOYEE table (Table 9.8)

Q.The following query selects details of all those employees whose name consists of exactly 5 letters and starts with any letter but has 'ANYA' after that.

The real EMPLOYEE table (Table 9.8)

🎓Unlock everything free for 14 days

Unlock everything free for 14 days