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