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