Relational Tables 3881 An empty set (no matching records) returns the following information: Empty set (0.00 sec) To issue a query that returns a set of table columns, use the  select()  method and specify the columns to return between square brackets. This query returns the Name and CountryCode columns from the city table. | 4079 | Rafah | PSE | Rafah |{"Population": 92020} | +------+------- ----+-------------+------------+-------------------------+ 4082 rows in set (0.01 sec) You can separate a value from the search condition by using the  bind()  method. For example, instead of using "Name = ’Z%’ " as the condition, substitute a named placeholder consisting of a colon followed by a name that begins with a letter, such as  name . Then include the placeholder and value in the  bind() method as follows: mysql-py>  db.city.select(["Name", "CountryCode"]).where( "Name like :name").bind("name", "Z%") To issue a query that returns rows matching specific search conditions, use the  where()  method to include those conditions. For example, the following example returns the names and country codes of the cities that start with the letter Z. Filter Searches mysql-py>  db.city.select(["Name", "CountryCode"]) +-------------------+-------------+ | Name | CountryCode | +-------------------+-------------+ | Kabul | AFG | | Qandahar | AFG | | Herat | AFG | | Mazar-e-Sharif | AFG | | Amsterdam | NLD | ... ... | Rafah | PSE | | Olympia | USA | | Little Falls | USA | | Happy Valley | USA | +-------------------+-------------+ 4082 rows in set (0.00 sec) mysql-py>  db.city.select(["Name", "CountryCode"]).where("Name like ’Z%’") +-------------------+-------------+ | Name | CountryCode | +-------------------+-------------+ | Zaanstad | NLD | | Zoetermeer | NLD | | Zwolle | NLD | | Zenica | BIH | | Zagazig | EGY | | Zaragoza | ESP | | Zamboanga | PHL | | Zahedan | IRN | | Zanjan | IRN | | Zabol | IRN | | Zama | JPN | | Zhezqazghan | KAZ | | Zhengzhou | CHN | ... ... | Zeleznogorsk | RUS | +-------------------+-------------+ 59 rows in set (0.00 sec)