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

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

Universal Scrobbler

Universal Scrobbler is an app that allows you to update last.fm with tracks you have heard, but not on iTunes. Most importantly this allows you to select tracks played by BBC radio in the last 9 hours.
Read more

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