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