replace bits of fields in mysql
// replace bits of fields in mysql
update `table_name` set field_name = replace(field_name,"oldtext","newtext")
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
Rob Nugen http://robnugen.com
update `table_name` set field_name = replace(field_name,"oldtext","newtext")