MySQL update values in array

Question

my array in DB looks like this:

a:2:{i:0;s:6:"first";i:1;s:9:"second";}

So output is like:

1 => first
2 => second

How can I update eg. only 1st value?

I'm not sure what you mean by array in DB. Could you explain a bit more about that? — Hopeful Llama
– Hopeful Llama, Commented May 17, 2016 at 10:35
a:2:{i:0;s:6:"first";i:1;s:9:"second";} <- this is a value in column meta_value. When I add new position it will be eg. a:3:{i:0;s:6:"first";i:1;s:9:"second";i:2;s:5:"third";} — Szmerd
– Szmerd, Commented May 17, 2016 at 10:39

codedge · Accepted Answer · 2016-05-17 10:41:34Z

4

Your string in your DB is a serialized array. You first need to unserialize it and then you can modify the values.

answered May 17, 2016 at 10:41

codedge

5,1892 gold badges29 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1