Updating Data in MYSql update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); For moving wordpress installs to repair the guid UPDATE wp_posts SET guid = replace( guid, ‘web/’, ” ) ;
Tag Archives: data manipulation
Incrementing values in Mysql
As the saga continue manipulating data this comes in handy to increment all the id’s in a table UPDATE jos_content_old SET id = id + 50 WHERE (id = id) Keep in mind the resulting id being set must be higher thatn any existing ones or ther will be an error.