home / fixtures

Search neighborhoods

Demonstrating simple like search

Custom SQL query returning 15 rows

                        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
Arcadia Planitia Memnonia MC
Bernal Heights San Francisco CA
Corktown Detroit MI
Dogpatch San Francisco CA
Downtown Los Angeles CA
Downtown Detroit MI
Greektown Detroit MI
Hayes Valley San Francisco CA
Hollywood Los Angeles CA
Koreatown Los Angeles CA
Los Feliz Los Angeles CA
Mexicantown Detroit MI
Mission San Francisco CA
SOMA San Francisco CA
Tenderloin San Francisco CA
Powered by Datasette · Query took 0.596ms