Archive for the ‘phpMyAdmin’ Category

MYSQL Query clear all data in a column

Tuesday, December 13th, 2011

UPDATE table SET column = ”

example:

UPDATE wp_posts SET post_excerpt = ”

MySQL phpMyAdmin text string find replace Query

Sunday, April 25th, 2010

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