MySQL使用RegEx来更新/选择列

I searched in the internet for an answer to select every columns that matches regex pattern. I didn't find one, or maybe I did, but I didin't understand it, because I'm new to DataBases. So here's the sql I was trying to run:I searched in the internet for an answer to sel