Estimated reading time: 0 minutes, 15 seconds
What MySQL query will do a text search and replace in one particular field in a table?
UPDATE [table_name] SET [field_name] = REPLACE([field_name], "foo", "bar");
(ie. search for 'foo' and replace with 'bar' so a record with the value : 'hello foo' becomes: 'hello bar')
Zeeshan Arshad is a multipotentialite web developer who also happens to know about growth hacking, blogging, closing, marketing, copywriting, spirituality, virtual reality and more. Zeeshan is a Freelancer Top Contributor, vWorker Top Coder and Udemy Premium Instructor.Story LinkedIn Profile Courses YouTube