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