archives

search and replace in mysql

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