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