• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
Foster Solutions (FSI)

Foster Solutions (FSI)

The Solution is in the Process

  • Home
  • What We Do
    • Websites / Hosting
      • Author’s Sites
      • Boutique Websites
      • Corporate Websites
      • Open Source CMS
      • Quick and Dirty Websites
    • SQL Databases / VBA Automation
    • GIS / Market Research
    • Government/Planning
  • Case Studies
    • Databases/Automation Case Studies
    • GIS/Market Research Case Studies
    • Local Government Case Studies
    • FSI – crosspollination – examples
  • Clients
  • Articles
  • Contact Us

mysql

You are here: Home / Archives for mysql

WordPress: SQL to Bulk Move Categories to Tags

June 15, 2014 by doug

There are tools out there but if you need to move all or most of the categories to tags then it is best to do it manually using SQL. Remember that category 1 is the default uncategorized so don’t move it.  The code below allows you to select which category ids will not be moved …

Read moreWordPress: SQL to Bulk Move Categories to Tags

Changing Media Attachment in WordPress (SQL)

October 7, 2010 by doug

WordPress seems limited with the way it handles images (media).  I don’t see why it can’t be part of the taxonomy like posts and pages since it is stored in the wp_posts table.  A media item is “attached” to a post if it has a value in the post_parent field.  It can only be attached …

Read moreChanging Media Attachment in WordPress (SQL)

Ready to get started?

Client Survey

Please take this survey if you are interested in a new or modified website. We will assess and get back with you as soon as possible.

Finding Solutions

We work with you to make things faster, easier and better.

Sites

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Features

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Support

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Copyright © 2021 · Foster Solutions (FSI) · All Rights Reserved

Back to top