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’);