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