mysql - 用Python怎么在一个字符串里面取到想要的数据？

Question

从数据库中提取到一个字符串。
a:2:{i:27;a:6:{s:3:"did";i:27;s:3:"num";i:1;s:8:"discount";s:1:"0";s:5:"price";s:2:"40";s:4:"name";s:12:"芒果雪冰";s:5:"omark";s:0:"";}i:36;a:6:{s:3:"did";i:36;s:3:"num";i:1;s:8:"discount";s:1:"0";s:5:"price";s:2:"40";s:4:"name";s:12:"抹茶雪冰";s:5:"omark";s:0:"";}}

现在要取出其中的“芒果雪冰”跟“抹茶雪冰”，用什么方法呢。。

Answer 1

Isn’t this the result of PHP serialization? Regular expressions are the best for python

Answer 2

Use regular expressions to match strings preceded by "s:12:" and followed by quotes.

import re
match_list = re.findall('(?<=s\:12\:)\".+?\"', s1)

Answer 3

It is not recommended that you use regular expressions to extract. For regular data, the best way is to use the corresponding parsing format, which is json. It is recommended that you use json to parse directly, of course, if you need it. You can use it directly to extract Chinese.

^[u4E00-u9FA5]+$

Answer 4

This is the serialization of PHP variables. There is a third-party module in Python called phpserialize that can convert it to Python data types. Specific tutorials can be found here:
Python uses PHP serialized data

If possible, please extract it yourself. Okay?