MySQL - how to update only some characters in a column value - longtext (DC2Type:array)

0 votes

1 answer

64 views

                          MySQL: 8.0.35 - Source distribution

I have longtext (DC2Type:array) column and incorrect some characters values in a column string, so i want to replace this data format:

    a:2:{s:7:"content";s:6:"text 1";s:3:"url";s:19:"https://someurl.com ";}

to this data format:

    a:2:{i:0;s:6:"text 1";i:1;s:19:"https://someurl.com ";}

so replace:
s:7:"content"
to:
i:0

and replace:
s:3:"url"
to:
i:1

how to do it ?

regards

Asked by Pawel W (27 rep)

Jul 8, 2024, 05:17 PM
Last activity: Jul 10, 2024, 10:45 AM

MySQL - how to update only some characters in a column value - longtext (DC2Type:array)

Related Questions