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