[SOLVED] return a name containing a string from table

[hackypro]

SELECT Continent, Region, COUNT(*)
FROM Country
WHERE Region LIKE '%Continent%'
GROUP BY Continent, Region;

 

is what i have. basically i need to return regions where the continent name is inside the region name. apparently need to use a MYSQL function here but i'm stumped

[Barand]

WHERE INSTR(region, continent)

[hackypro]

AWESOME I LOVE YOU