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