Matching urls
In this lesson you learned that SQL Server provides the LIKE
operator, which determines if a string matches a specified pattern.
You need to verify the URLs of the official sites of every series. You prepare a script that checks every official_site
value from the series
table to analyze possible wrong URLs.
To make it easier, suppose that the format of the URLs you have to validate must start with 'www.'
, although we know that there are URLs that have other beginnings.
This exercise is part of the course
Cleaning Data in SQL Server Databases
Exercise instructions
- Select the URLs of the official sites.
- Get the URLs that don't match the pattern.
- Write the pattern.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
name,
-- URL of the official site
___
FROM series
-- Get the URLs that don't match the pattern
WHERE official_site ___ ___
-- Write the pattern
'___'