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

RT @jburnmurdoch: Most useful thread I’ve read on the dynamics of Covid transmission. By an expert, and packed full of links to evidence. Indoor spaces and or prolonged face-to-face contact account for large majority of Covid transmission. Walking past someone in street/park much lower risk. https://t.co/fnMrDjAxfq

Most useful thread I’ve read on the dynamics of Covid transmission. By an expert, and packed full of links to evidence. Indoor spaces and or prolonged face-to-face contact account for large majority of Covid transmission. Walking past someone in street/park much lower risk. https://t.co/fnMrDjAxfq — John Burn-Murdoch (@jburnmurdoch) May 17, 2020 from Twitter https://twitter.com/danbrewer
Read more