Using the set type
This example uses the following table and index:
CREATE CUSTOM INDEX IF NOT EXISTS teams_idx ON cycling.cyclist_career_teams (teams) USING 'StorageAttachedIndex';
An index is created on the set column teams
in the cyclist_career_teams
table.
Query with CONTAINS
from the set teams
column:
SELECT lastname, teams FROM cycling.cyclist_career_teams
WHERE teams CONTAINS 'Rabobank-Liv Giant';
Results