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