如何从具有多个值的字段中提取数据？

Question

IP.Nexus puts custom fields into a table all muddled up into one row and some how pulls the correct data out.

basically my custom fields row looks like so:

a:2:{i:2;s:4:"Test";i:3;s:10:"Accounting";}

How do i select what item to pull as i would like to out put just one item not the whole row, is it with delimiters or string splitter, as i am novice with this part of mySQL

Cause i would like to echo out just the advertising on its own and also vice versa for the testing.

Thanks in advance

Answer 1

It's a serialized array using serialize() function so you can get its contents using unserialize($YourString);.

But I see that you string is corrupted for deserialization, because s:4: in s:4:"advertising" says that after s:4: 4 character long string is expected that advertising is not.