Tag Archives: data transfer

Find and replace in MYSQL

Posted on April 23, 2011 by mindeater

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/’, ” ) ;

Posted in MySQL, Wordpress | Tagged , , , , | Comments Off

moving data in sql

Posted on November 5, 2010 by mindeater

So after searching around the web looking for code to get data from one table intop another I found this example posted on the mysl dev forum mysql> INSERT INTO orders (customer_cust_id, orderdatetime, message, taxrate, shippingprice) -> SELECT ’1′, NOW(), … Continue reading →

Posted in MySQL | Tagged , | Comments Off