Get startedGet started for free

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

View Course

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
	'___'
Edit and Run Code