12.2.6. LIKE – Pattern Matching

Try these first

1. 1.

   Write a SQL query to find users with emails that end with '@yahoo.com'.

   Hint

   Use the wildcard '%' before '@yahoo.com'.

2. 2.

   How would you find all products that start with 'Electro'?

   Hint

   Remember to use the wildcard '%' at the end.

3. 3.

   What does the LIKE operator do in SQL?

   • A. Deletes records
   • B. Searches for a specified pattern
   • C. Updates records

   Hint

   Think about what type of operation you perform with `LIKE`.

4. 4.

   True or False: The percent sign (%) in a LIKE clause can only appear at the end of the pattern.

   • True
   • False

   Hint

   Consider how wildcards can be used in different placements.

5. 5.

   You are tasked with writing a SQL query that catches all email addresses beginning with 'info' and ending with a domain, ensuring both conditions are met.

   Hint

   Consider how to just capture valid domain emails.

6. 6.

   Design a query to fetch all phone numbers that contain the digit '5' anywhere in them and end with '7'.

   Hint

   Utilize the '%' wildcard effectively before '5' and place '7' at the end.