Search neighborhoods

Demonstrating simple like search

Custom SQL query returning 6 rows (hide)

select neighborhood, facet_cities.name, state
from facetable
    join facet_cities
        on facetable.city_id = facet_cities.id
where neighborhood like '%' || :text || '%'
order by neighborhood;

Query parameters

neighborhoodnamestate
Corktown Detroit MI
Downtown Los Angeles CA
Downtown Detroit MI
Greektown Detroit MI
Koreatown Los Angeles CA
Mexicantown Detroit MI
Powered by Datasette · Query took 0.97ms