How to replace a string in mySQL row that has many strings separated by commas?

Question

In mySQL under the column extra I have fields like the following (in one field per row)

Radio CD,Immobilizer,Multitronic Cr,Air Condition

The problem is that instead of Multitronic Car I wrote Multitronic Cr without a in about 300 rows.

How to fix this?

score 0 · Accepted Answer · edited May 23 '17 at 12:05

0

Please check the similar SO question but in your case it should be similar to:

UPDATE table_name

SET `extra` = REPLACE (`extra`, 'Multitronic Cr', 'Multitronic Car')

WHERE `extra` LIKE '%Multitronic Cr%'

edited May 23 '17 at 12:05

Community

answered Oct 25 '14 at 10:51

Kypros

efxaristo file alla den katalavo to articleItem – EnexoOnoma Oct 25 '14 at 10:56
copy/paste error, should be your column name. fixed now. Also put your correct `table_name` in there. – Kypros Oct 25 '14 at 10:57
thank you. douleveis kapou i ise monos sou ? – EnexoOnoma Oct 25 '14 at 11:04
Kai se eteria kai monos mou file giati? – Kypros Oct 25 '14 at 11:06
logika tha me endiaferei sinergasia per projects ke exo ellipsi prosopikou. en exeis kapoio link sto profile sou i kati – EnexoOnoma Oct 25 '14 at 11:21
chat here: http://www.chatzy.com/25282097780494 me password arithmous 654321 – Kypros Oct 25 '14 at 11:43
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/63631/discussion-between-kypros-and-xalloumokkelos). – Kypros Oct 25 '14 at 11:58
tora to eida to minima – EnexoOnoma Oct 27 '14 at 12:27

1 Answers1