home / fixtures

Search neighborhoods

Demonstrating simple like search

Custom SQL query returning 6 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
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.844ms