Replace part of text in sql database

Asked Dec 18 '18 at 10:11

Active Apr 16 '20 at 15:16

Viewed 33 times

I need to replace parts of text using the following query:

UPDATE table_name SET field = REPLACE(field, 'old', 'new')

The problem is that the query must not replace "old.jpg" or "oldcar" and so on, but ONLY "old".

Can we use something like below?

WHERE field LIKE 'old'

edited Apr 16 '20 at 15:16

rd3n

asked Dec 18 '18 at 10:11

Silvano Ambrosini

You might like this answer https://stackoverflow.com/a/50984816/1626878 – Sahil Mahajan Mj Dec 18 '18 at 10:20
Thank you Sahil, – Silvano Ambrosini Dec 18 '18 at 10:27
What database, DBMS, are you using? – Joakim Danielson Dec 18 '18 at 10:28
Thank you Sahil, I need to replace about 20.000 different item numbers with 20.000 different link to the related objects: i prepared a xlsx with 20.000 queries like this UPDATE table SET field = REPLACE (field,"10.300.17","10.300.17"); it works well, but unfortunately replaces also 10.300.17.jpg and so on. – Silvano Ambrosini Dec 18 '18 at 10:36
is a standard MySQL innoDB – Silvano Ambrosini Dec 18 '18 at 10:43
Why can't you do `WHERE field = '10.300.17'`, it will not match 10.300.17.jpg? What am I missing? – Joakim Danielson Dec 18 '18 at 12:53
Hello Joakim and thanks: the field is a (quite long) text field and in this text you can find both "10.300.17" and also 10.300.17.jpg" . and I can't use << WHERE field = '10.300.17'>> because the query does not find anything to replace. – Silvano Ambrosini Dec 20 '18 at 06:14

0 Answers0