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