BETWEEN is a SQL operator that selects values within a given range, inclusive of both endpoints. It's a shorthand for using >= and <= comparisons together. The syntax is 'BETWEEN value1 AND value2' which specifies a range to test in WHERE clauses. It doesn't specify column lists, table lists, or simple value lists - those use IN or other operators.