How to replace words in specific column using mysql?

Asked May 17 '22 at 20:50

Active May 17 '22 at 20:52

Viewed 15 times

I have a table myspec with record like below. It has more than 100 records. I want to replace based on some condition. How do I replace words inside a string in MYSQL?

id definition:

1  <id>1234</id>
   <name>sbc</name>
   <spec class = "com.fs.one">
     <x class = "">
     </x>
    <y class = "">
     </y>
   </spec>

2  <id>890</id>
   <name>test</name>
   <spec class = "com.fs.five">
     <x class = "">
         <x class = "">
         </x>
         <y class = "">
         </y>
     </x>
   </spec>

How do I replace <spec...> </spec> with my new value @newdefinition?

@newdefinition  = "<spec class = "com.fs.new"> 
                    <x class = "">
                        <x>
                        </x>
                        <y>
                        </y>
                    </x>
                    <y>
                    </y>"

edited May 17 '22 at 20:52

Tim Lewis

27,813
13
73
102

asked May 17 '22 at 20:50

shree

2,745
7
28
35

What version of MySQL? If you're using 8.0 you can use `REGEXP_REPLACE()`. – Barmar May 17 '22 at 20:53
How to do that? coz we have specs value with different – shree May 17 '22 at 21:04
1

Replace the regular expression `` with `@newdefinition` – Barmar May 17 '22 at 21:14
That's the whole point of using a regular expression. You use a wildcard for the variable part. – Barmar May 17 '22 at 21:16

How to replace words in specific column using mysql?

0 Answers0