how to replace text using a query

Question

How do I replace certain text in a field using sql?

Example Table:

id               text
-------------------------------
1        hello my name is keven
2        hello my name is steve
3        hi my name is sam

How would I replace hello with hi in the field text while leaving the remaining text untouched?

Nesim Razon · Accepted Answer · 2012-04-22 20:40:22Z

2

UPDATE YOUR_TABLE SET `text` = REPLACE(`text`, 'hello', 'hi')

answered Apr 22, 2012 at 20:40

Nesim Razon

9,8043 gold badges38 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yoav Kadosh · Accepted Answer · 2012-04-22 20:40:33Z

1

as seen in this article

update TABLE_NAME set 
FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);

answered Apr 22, 2012 at 20:40

Yoav Kadosh

5,2154 gold badges44 silver badges58 bronze badges

RadBrad · Accepted Answer · 2012-04-22 20:42:10Z

0

Select id, REPLACE(text,'hello','hi') AS text from table;

It's somewhat database dependent, but that should work on most databases.

answered Apr 22, 2012 at 20:42

RadBrad

7,3142 gold badges26 silver badges17 bronze badges