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%';

 

Recent Posts

Generate Slug URL in MySQL

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

7 years ago

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

[crayon-68bd40cbde066564432275/]  

7 years ago

SELECT Null

[crayon-68bd40cbde43e577239603/]  

7 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-68bd40cbde67e000524768/]  

7 years ago

ADD new Column – pgSQL

[crayon-68bd40cbde80f435121290/] [crayon-68bd40cbde814974640444/]  

7 years ago