when dealing with the data of a mysql table, it is encountered that the content stored in a field is as follows:
a:2:{
i:0;
a:2:{i:0;i:0;i:1;s:9:"";}
i:1;
a:2:{i:0;i:0;i:1;s:9:"";}
} I want to use sql to put forward the names and generate characters such as "Zhu Taiping, Liu Zhongfu" . How can I extract them?
this is not JSON data, but PHP serialized data. It is difficult to extract
as mentioned above, this is not JSON format, but PHP serialized data, which is actually a two-dimensional array:
Array
(
[0] => Array
(
[0] => 0
[1] =>
)
[1] => Array
(
[0] => 0
[1] =>
)
)it is not easy to extract strings directly with SQL. If you are using PHP, you can use PHP's method:
echo join(',', array_map(function($a) { return $a[1]; }, unserialize($data)));the simple table structure is as follows < table > < thead > < tr > < th > ID < th > < th > TypeID < th > < tr > < thead > < tbody > < tr > < td > 1 < td > < td > [1,2] < td > < tr > < tr > < td > 2 < td > < td > [2,3] < td > < tr...
when dealing with the data of a mysql table, it is encountered that the content stored in a field is as follows: a:2:{ i:0; a:2:{i:0;i:0;i:1;s:9:"";} i:1; a:2:{i:0;i:0;i:1;s:9:"";} } I want to use sql to put forwa...