SQL for partial string comparison

gistfile1.txt

--Option 1
select  metropolitanarea,
        nhl_team,
        team,
        win,
        loss 
from cities_expanded c,
     nhl_data n
where n.team like '%' || nhl_team || '%';

--Option 2
select  metropolitanarea,
        nhl_team,
        team,
        win,
        loss 
from cities_expanded c, nhl_data n
where n.team ~ nhl_team ;

--Option 3
select  metropolitanarea,
        nhl_team,
        team,
        win,
        loss
from cities_expanded c, nhl_data n
where  position(c.nhl_team in n.team ) > 0;