MySQL Forums
Forum List  »  Newbie

difficulty with the replace function
Posted by: Jean-Jacques Juille
Date: February 26, 2023 08:16AM

Good morning,
I work with Mysq 8.1.13,
I have a table called 'oc_setting'
In the column whose name is 'value' I have the following string:
a:1:{i:0;s:7:"2102536";}
I want to replace with the following string:
a:1:{i:0;s:7:"1234567";}
I want to do this replacement only in the row whose column whose no is 'key' is equal to:
'payline_primary_contracts'
Can you help me because I can't.
Thank you beforehand.
Note: perhaps forgive my bad English but I use Google Translate because I am French and speak English very badly.

Options: ReplyQuote


Subject
Written By
Posted
difficulty with the replace function
February 26, 2023 08:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.