Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
Filtering by row
Extracting data by column
15. Using contains()
Practice using filter() and select()
The pipe operator
Sorting rows
Summary

## Instruction

We can also select columns based on their contents. If we wanted all columns with the word "population" in their name, we could enter each column name ourselves.

But there's a better way: using the contains() function. The string we want to match goes inside the contains() function, which becomes the second argument in the select() function. If the column name matches the contents of contains(), it will be selected.

To select all columns with "population" in their names, we'd use:

select(countries, contains("population"))

## Exercise

Select columns with "area" in their name using contains().

### Stuck? Here's a hint!

Type:

select(countries, contains("area"))