SELECT building_full_name FROM Apartment_Buildings WHERE building_full_name LIKE "%court%"
Find all the building full names containing the word "court".
SELECT building_full_name FROM Apartment_Buildings WHERE building_full_name LIKE `` % court % ''
select building_full_name from apartment_buildings where building_full_name like value
Find all the building full names containing the word `` court '' .