Plurk paste

SELECT name,
CASE WHEN continent in ('Europe','Asia')  THEN 'Eurasia'
     WHEN continent in ('North America','South America','Caribbean') THEN 'America'
            ELSE continent END
     FROM world
WHERE name LIKE '[AB]%'