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