how to Un Serialized array

[v2boy]

a:2:{i:0;a:6:{s:8:"order_id";i:4643;s:7:"item_id";i:3584;s:4:"name";s:96:"Asd 1box of 10pcs";s:3:"qty";i:1;s:7:"shipped";i:0;s:6:"status";s:11:"not-shipped";}i:1;a:6:{s:8:"order_id";i:4643;s:7:"item_id";i:3585;s:4:"name";s:62:"Fashion kids pink Asd";s:3:"qty";i:5;s:7:"shipped";i:0;s:6:"status";s:11:"not-shipped";}}

how to Un Serialized array

[pawan-saxena]

you cannot unserialize whole string at once. Only one key which you want at a time.

SELECT getPhpSerializedArrayValueByKey(_input_string,key_you_want_to_unserialize)

More : https://github.com/Nobiles2/MySQLToolBox/blob/master/getPhpSerializedArrayValueByKey_README.md