How to Find & Replace Data in MySQL

How to Find & Replace Data in MySQL

To find a string in a certain field and replace it with another string:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
via mediacollege.com

Posted via web from danbrewer's posterous

Comments

Post a Comment

Popular posts from this blog

RT @CancerInNorwich: 📢 Join us on Monday at 1pm for the next talk in our virtual seminar series. We will be hearing from Dr Wafa Al-Jamal from @QUBelfast, who will be talking about "Smart Nanomedicimes for Pancreatic Cancer". All are welcome to join via the MS Teams link: https://t.co/4xCYpjGuBZ https://t.co/EGyD4NAgeP

RT @CancerInNorwich: 📢 Join us on Monday at 1pm for the next talk in our virtual seminar series. We will be hearing from Dr Wafa Al-Jamal from @QUBelfast, who will be talking about "Smart Nanomedicimes for Pancreatic Cancer". All are welcome to join via the MS Teams link: https://t.co/4xCYpjGuBZ https://t.co/EGyD4NAgeP — Daniel Brewer (@danbrewer) May 11, 2023 from Twitter https://twitter.com/danbrewer
Read more

RT @CancerInNorwich: We're at The Forum until 4pm! Come and learn about how we can test for prostate cancer, play our puzzle game and make tissue slides! #CancerInNorwich https://t.co/zEapurramu

RT @CancerInNorwich: We're at The Forum until 4pm! Come and learn about how we can test for prostate cancer, play our puzzle game and make tissue slides! #CancerInNorwich https://t.co/zEapurramu — Daniel Brewer (@danbrewer) Feb 18, 2023 from Twitter https://twitter.com/danbrewer
Read more

A census of amplified and overexpressed human cancer genes : Nature Reviews Cancer

This paper , that I am an author on, was released on 24th December 2009: "Integrated genome-wide screens of DNA copy number and gene expression in human cancers have accelerated the rate of discovery of amplified and overexpressed genes. However, the biological importance of most of the genes identified in such studies remains unclear. In this Analysis, we propose a weight-of-evidence based classification system for identifying individual genes in amplified regions that are selected for during tumour development. In a census of the published literature we have identified 77 genes for which there is good evidence of involvement in the development of human cancer." I spent a huge amount of time on this one but I am still pretty low on the author pecking order. This is for a super high impact journal, "Nature Reviews Cancer" which has a 2008 ISI Impact Factor of 30.762. Also check out the associated website which I put together just before Christmas. Hopefully, this...
Read more