How to use mySQL replace() to replace strings in multiple records?

try like below,

UPDATE tableName

SET StringColumn = REPLACE (StringColumn, 'SearchForThis', 'ReplaceWithThis')

WHERE SomeOtherColumn LIKE '%PATTERN%'
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Genuine websites to earn money.

If you are interested in PTC sites then this article is for you. I have personally tried many of the sites and found that the best thing ...

  • jsf forum
    Introduction We assume that you've configured JSF to interpret empty string submitted values as null by the following context param...
  • Best Ways to Get Hired
    if you are looking for a job, it has come the time that you can miss. It is time to get ready so you can get prepare to find the job of yo...
  • Genuine websites to earn money.
    If you are interested in PTC sites then this article is for you. I have personally tried many of the sites and found that the best thing ...