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