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