Categories: Snippets

MySQL Search and Replace Query

UPDATE  `MySQL_Table` SET  `MySQL_Table_Column` = REPLACE(`MySQL_Table_Column`, 'oldString', 'newString') WHERE  `MySQL_Table_Column` LIKE 'oldString%';

 

Share

Recent Posts

Generate Slug URL in MySQL

A slug is a short name using human-readable keywords to identify a web page. For…

5 years ago

How to use SQL NOT LIKE condition with multiple values in PostgreSQL?

[crayon-6639918294d88775896163/]  

6 years ago

How to use SQL LIKE condition with multiple values in PostgreSQL?

[crayon-6639918294e9e513167363/]  

6 years ago

SELECT Null

[crayon-6639918294fc6356541876/]  

6 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-66399182950e8523999647/]  

6 years ago

ADD new Column – pgSQL

[crayon-663991829525d089367948/] [crayon-6639918295263029948666/]  

6 years ago