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]');

Posted via web from danbrewer's posterous

Comments

Popular posts from this blog

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

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