In mysql, I have a db column with BLOB
data type.
The blob data looks something like this:
{\"Name\":\"Mike Smith\",\"Number\":\"1\"}
or
[{\"Name\":\"Mike Smith\"},{\"Name\":\"Jon Doe\",\"Spaces\":\"1\"},{\"Name\":\"My Space(s)\"},{\"Name\":\"Rear\"}]
I am trying to detect the content in php and saving the string as a variable as such:
{\"Name\":\"Mike Smith\",\"Number\":\"1\"}
BECOMES -> Mike Smith(1)
And...
[{\"Name\":\"Mike Smith\"},{\"Name\":\"Jon Doe\",\"Number\":\"1\"},{\"Name\":\"My Space(s)\"},{\"Name\":\"Rear\"}]
BECOMES --> Mike Smith, Jon Doe(1), My Space(s), Rear
I am not familiar with BLOB data type and wanted to get some help from the community. How would I manipulate the BLOB data to above?
Any suggestions will be much appreciated.