关键字extractvalue SELECT extractvalue(CONTENT, "/opinion/date") as AAA, extractvalue(CONTENT, "/opinion/content") as BBB FROM XXXXX CONTENT字段存的xml: <opinion> <date>2021-08-20 03:03:53</date> <user>XXX</user> <content>XXX</content> </opinion>