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