MYSQL Query clear all data in a column
Tuesday, December 13th, 2011UPDATE table SET column = ”
example:
UPDATE wp_posts SET post_excerpt = ”
Archive for the ‘phpMyAdmin’ Category
MySQL phpMyAdmin text string find replace Query
Sunday, April 25th, 2010update 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’);