MySQL phpMyAdmin text string find replace Query

update TABLE_NAME set FIELD_NAME =
replace(FIELD_NAME,’find this string’,’replace it with this one’);

example (for videodb to turn all “wanted” titles into “DVD” titles):

update videodb_videodata set mediatype =
replace(mediatype,’50’,’1’);

Comments are closed.