How do you search a DB for values and display the results in a repeating group?

I have a default page with a defined workflow to load ten cities with various climates. I want to do a static search as a dropdown of {Hot, Cold, Warm} that queries the database climate field with a
wildcard that can return “moderately warm” as the warm query selected in the drop-down and display all of the warm cities in the repeating list

Not sure where to start. Any insight would be helpful.
Thanks