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

Tag Archives: sql

MYSql copy tables

Posted on: April 27, 2011 by mindeater

create table tablename_new like tablename; -> this will copy the structure… insert into tablename_new select * from tablename; -> this would copy all the data

Posted in MySQL | Tagged mysql, sql

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

WordPress Plugin Query

Posted on: November 18, 2010 by mindeater

I am often cutting and pasting this in wordpress plugins $query = “SELECT id, post_title FROM ” . $wpdb->prefix . “posts WHERE post_type = ‘wpf_venue’ AND post_status=’publish’”; $venues = $wpdb->get_results ( $query, ARRAY_A );

Posted in plugins, Wordpress | Tagged $wpdb, database connection, plugin, sql, wordpress

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