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