Home » forums » Programming » Database Software

search and replace in mysql

byo71's picture
Submitted by byo71 on Thu, 2008-02-14 00:03. Communications | Database Software

can also be used in phpmyadmin

UPDATE tablename SET tablefield = replace(tablefield, "findstring", "replacestring");

very handy for changing all entries in one field to another value

» login or register to post comments | previous forum topic | next forum topic