SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE "%film%"
Find all the locations whose names contain the word "film".
SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE `` % film % ''
select location_name from locations where location_name like value
Find all the locations whose names contain the word `` film '' .