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