How to iterate through all mysql rows?

Question

MySQL

There is a table 'name'. 'name_yotube' column.
The column has two options:
either like this a:2:{s:2:"id";s:0:"";s:4:"info";s:0:"";}
or like this a:2: {s:2:"id";s:24:" here is a string like: UC9nxc-xiH1AnL9RGstfgurg ";s:4:"info";s:15:" (here or so HTTP/1.0 200 OK or HTTP/1.0 404 Not Found) ";}
You need to go through all the lines and change the data, that is, replace these arrays with id, that is, UC9nxc-xiH1AnL9RGstfgurg
It seems that he clearly explained.
What do you advise?

Answer 1

what is there to advise ... maybe regular seasons, or take everything in parts in PHP which one, deserialize and save what you need.