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