select() keeps the columns you name, in the order you name them: select(orders, order_id, region, units). A minus sign drops a column and keeps the rest: select(-discount).
Helpers pick columns by their names: starts_with("hour"), ends_with("_id"), contains("rate"). where(is.numeric) picks columns by type.
rename(new_name = old_name) changes a name and keeps every column where it was. You can also rename inside select(), but then only the named columns survive, which is a common surprise. relocate() moves columns without dropping any: relocate(priority) puts it first.
Keep named columns, drop one, pick by a name pattern, and rename while keeping the rest.