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