SELECT id, name, parent FROM villa_loc WHERE name LIKE 'Cote%dAzur' OR name LIKE 'Cote%dAzur-Cote dAzur' OR name LIKE 'Cote%dAzur area' OR name LIKE 'Cote%dAzur city' OR name LIKE 'Cote%dAzur coast' OR name LIKE 'Cote%dAzur island'