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