How to change a texture with character proximity

Hi, I’m wondering whether its possible to change the texture on a mesh when the player character is near - Like an aura of X radius around the player that causes 1 texture to blend into another, and then back again when the character moves away.

I’ve been looking at material instancing but can’t work out how to change textures based on character proximity, is something like this even possible?