How do I select rows from a DataFrame based on column values?

How can I select rows from a DataFrame based on values in some column in Pandas?

In SQL, I would use:

SELECT *
FROM table
WHERE column_name = some_value