Update a word in full name in mysql query

Question

I need to update only one word in ful name .For exp. I have a name "Abc Cde LEF PQr".I want to replace Abc with Thg. I have used query to find names which contains Abc

SELECT * FROM `table` WHERE `name` LIKE '%Abc%'

Please help me to do next step to replace the word

Duplicate: http://stackoverflow.com/questions/1876762/mysql-way-to-update-portion-of-a-string — Mark Miller, Jun 04 '14 at 07:49
And just for future reference, if you googled `mysql replace` the first and second links would have sent you to the functions linked below by most of those who answered. I'm just saying that there was a little more room to try on your own before you asked this question. — Catalin Deaconescu, Jun 04 '14 at 07:53

score 1 · Accepted Answer · answered Jun 04 '14 at 07:48

1

try this

UPDATE table  SET column = REPLACE(column, 'abc', 'thg');

answered Jun 04 '14 at 07:48

Ezhil

996
8
13

score 1 · Answer 2 · answered Jun 04 '14 at 07:49

1

Something like this:

UPDATE `table` 
SET name = REPLACE(name, 'Abc', 'Thg')
WHERE `name` LIKE '%Abc%'

Reference:

REPLACE(str,from_str,to_str)

answered Jun 04 '14 at 07:49

Arion

31,011
10
70
88

score 0 · Answer 3 · answered Jun 04 '14 at 07:48

0

You can replace into the select query, it's not destructive for database data. Try :

SELECT
  REPLACE(field1, 'Abc', 'Thg')
FROM table
WHERE name LIKE '%Abc%'

answered Jun 04 '14 at 07:48

Pete_Gore

594
1
5
20

score 0 · Answer 4 · answered Jun 04 '14 at 07:49

0

You can use Replace Function

Try this

UPDATE table  SET name = REPLACE(name, 'abc', 'thg');
WHERE name LIKE '%Abc%'

answered Jun 04 '14 at 07:49

Vignesh Kumar A

27,863
13
63
115

Update a word in full name in mysql query

4 Answers4