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