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-692fa062dcbae818893585/]  

7 years ago

SELECT Null

[crayon-692fa062dcc7b876440316/]  

7 years ago

ALTER Column SET NOT NULL – pgSQL

[crayon-692fa062dcd3b489131046/]  

7 years ago

ADD new Column – pgSQL

[crayon-692fa062dcdda337365320/] [crayon-692fa062dcddd941793647/]  

7 years ago