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