Database Reference
In-Depth Information
Mill Stream Run Reservation
Buckeye Trail |
Hinckley Reservation
Bridle Connector Trail |
Rocky River Reservation
West Channel Pond Loop Trail |
Rocky River Reservation
Green Milkweed Trail |
Mill Stream Run Reservation
All Purpose Trail |
Euclid Creek Reservation
Connector Trail |
Bradley Woods Reservation
North Chagrin Reservation Bridle Trail |
North Chagrin Reservation
Connector Trail |
Garfield Park Reservation
BR2 |
Brecksville Reservation
Connector Trail |
Rocky River Reservation
Buckeye Trail |
South Chagrin Reservation
For sanity, we will also sort these entries as follows:
SELECT DISTINCT label_name, res
FROM chp02.trails
WHERE label_name NOT LIKE '%&%'
ORDER BY label_name, res;
Next, we want to search for all the records that match any of these unique trail
names.Thiswillgiveusthelistofrecordsthatwillserveasrelations.Thefirststep
indoingthissearchistoappendthepercent(
%
)signstoouruniquelistinorderto
build a string on which we can search using a
LIKE
query:
