Select Find and replace query Mysql

Question

How to figure out this query:

I want to find in column details where matches image.GIF with this query:

SELECT * FROM `news` WHERE details LIKE '%image.GIF%'

Then I have other column 'title' I want to rename these entries on 'title column' where related to above query.

UPDATE `news`
 SET `details` = replace(details, 'image.GIF', 'new_image.GI')

I hope It's understandable.

Column details - in this column to find all rows with text image.gif;

Column title - to rename all things inside to new_image.gif where belonging to details column;

Couldn't you just append the where clause to the end of your update? UPDATE `news` SET `details` = replace(details, 'image.GIF', 'new_image.GI') WHERE details LIKE '%image.GIF%' — Dave Chen
– Dave Chen, Commented Feb 17, 2016 at 21:22
Not sure I understand about what you want to do the column named 'title' which isn't present in your examples — Ray
– Ray, Commented Feb 17, 2016 at 21:26
You don't understand me correctly sorry. I want to rename related to details column entries in column title where matches image.GIF in details column! — ama rullz amarullzz
– ama rullz amarullzz, Commented Feb 17, 2016 at 21:28
@amarullzamarullzz ok, so if you have a record with a detail named 'image.gif' you want to change the title column entries to new_image.gif of both the title and details columns? — Ray
– Ray, Commented Feb 17, 2016 at 21:41

Rahul · Accepted Answer · 2016-02-17 21:34:28Z

2

Include the condition into a WHERE clause like

UPDATE `news`
 SET `title` = replace(title, 'image.GIF', 'new_image.GI')
WHERE details LIKE '%image.GIF%';

answered Feb 17, 2016 at 21:23

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

1 Answer 1