Select Single Column

Databases are made up of tables which are made up of columns (AKA "fields"). It's just like an Excel spreadsheet.

Our CashPal database has a users table with these columns:

• id (integer)
• name (string)
• age (integer)
• balance (float)
• is_admin (boolean: true/false)

There can be many records (rows) in this table, each representing a single user. For example, here are three user rows:

In the last lesson, we used the * wildcard to get all the columns. To select only a single column, we simply swap out the * for the name of the column.

Returns all columns from the users table:

SELECT * FROM users;

Returns only the name column from the users table:

SELECT name FROM users;