MySQL Forums
Forum List  »  General

Replace a string with another
Posted by: Solutions Specialized
Date: May 07, 2024 02:29AM

In a table, there is a field/column that has some data, I need to replace a number in the middle of the data that is different from one record to another.

For example "text text 123 text text", text maybe different from one record to another, but the number in the middle is the same, I want to be able to replace the number with another number.

This may not be applied to all records/entries in the table, but to some of them with may be selected based on another column like cat_id.

An SQL statement would be great to work on.

Any help is appreciated.


Options: ReplyQuote

Written By
Replace a string with another
May 07, 2024 02:29AM

Sorry, only registered users may post in this forum.

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.