mindeater – web / mobile solutions and engineering
Skip to content
  • About
  • Services
  • Scattered Notes
    • WordPress
    • Web Programming
    • MySQL
  • Contact

Tag Archives: data manipulation

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 data manipulation, data transfer, mysql, sql, wordpress

Incrementing values in Mysql

Posted on: November 8, 2010 by mindeater

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.

Posted in MySQL | Tagged data manipulation, mysql

Post navigation

Recent Posts

  • Get Posts that have featured Images
  • MySQL query logging
  • Network windows 7 and OS X
  • add xCode install of git to your path
  • OS X apache permissions

Recent Comments

    Categories

    • CSS
    • javascript
    • Joomla
    • MySQL
    • Online Purchases
    • OS X
    • PHP
    • plugins
    • Unix
    • Web Programming
    • Websites
    • Wordpress

    Web Hosting

    Web Special

    Tweets by @mindeater123

    $wpdb .LCK admin apache captcha cheap software checkbox codex command line css layout curl custom types database connection data manipulation data transfer DOM dreameaver elements essential plugins events find function geocode javascript joomla jQuery lock files maps md5 mysql php phpMyAdmin plugin POST scam software software versions sql submenus table-cell unix vertical alignment web service wordpress xml

    © 2023 mindeater – web / mobile solutions and engineering | Powered by JBST