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

Nationwide statement to QIF Format

Nationwide recently closed down the ability to get OFX statement files. These files were used to get transaction information into Microsoft Money and many other bits of accounting software. You can read more about it at the BetterOnlineBanking.co.uk website. I needed to find a way round this so that I could continue using Gnucash without resorting to typing everything in. Looking around I notices that the QIF format was pretty simple and so I have written two scripts: A Nationwide credit card statement to QIF converter A Nationwide flexaccount statement to QIF converter They are tested to work on both OS X and Linux and have zero requirements. Lets hope that Nationwide sort themselves out and produce a better way to do this. Usage Download the full statement in csv format from Nationwide Download the relevant script into the same directory Make the script executable: chmod +x NWCreditcsv2qif.sh Create the QIF file: ./NWCreditcsv2qif.sh NWCreditOct2009.csv > NWCreditOct2009.qif...
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