Querying a collection

You can query the database to find a collection containing a particular value.

To query a collection, include the name of the collection column in the select expression. For example, selecting the tags set returns the set of tags, sorted alphabetically in this case because the tags set is of the text data type:

SELECT id, tags FROM songs;


SELECT id, venue FROM songs;


The collection types are described in more detail in Using collections: set, list, and map.