Title: SQL Update – Website URL
Last modified: August 31, 2016

---

# SQL Update – Website URL

 *  Resolved [adambeaumont1](https://wordpress.org/support/users/adambeaumont1/)
 * (@adambeaumont1)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-update-website-url/)
 * I am trying to update all directory listings directly in the database to save
   time (rather than go through each listing individually. )
 * When I update the Website URL in the post_meta table it doesn’t save in the in
   the listing.
 * Example:
 *     ```
       a:2:{i:0;s:53:"http://www.example.com/website/10";i:1;s:42:"Football Club Fan site";}
       When I change to
       a:2:{i:0;s:53:"http://www.newwebsite.com/website/10";i:1;s:42:"Football Club Fan site";}
       ```
   
 * It saves in the database but doesn’t appear in the listing, the field appears
   blank. Any ideas? For some reason if I enter the same amount of characters it
   does appear in the listings.
 * [https://wordpress.org/plugins/business-directory-plugin/](https://wordpress.org/plugins/business-directory-plugin/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-update-website-url/#post-6988233)
 * Hi adambeaumont1,
 * We don’t recommend doing direct DB updates to manage the data in the tables unless
   you’re experienced with SQL and WP data formats in general. Doing so can have
   bad results.
 * Are you running a cache plugin here? Would that be impacting the data you’re 
   trying to change in some way? Cache plugins would prevent changes from showing
   in a live fashion.
 * If you’re just trying to update the field, I’d suggest using the Directory->Directory
   area of your site. It’s much easier.
 *  Thread Starter [adambeaumont1](https://wordpress.org/support/users/adambeaumont1/)
 * (@adambeaumont1)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-update-website-url/#post-6988311)
 * Thanks for the feedback. The main issue I have is that I have 5000 listings in
   the directory and need to change the URL on all of them, doing them individually
   would take some time.
 * The site uses no cache plugin, very strange why it wouldn’t appear. I am assuming
   the post_meta table is the only table I need to be updating.
 * I will look at using the import feature of the plugin, hopefully I can get figured.
 * Thanks.
 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-update-website-url/#post-6988322)
 * You might have a better time doing bulk updates like that doing a CSV export 
   with the sequence ID enabled, edit the CSV file and then do a bulk CSV import
   afterward. That might be easier, quicker and safer.
 * Docs on that here:
    [http://businessdirectoryplugin.com/docs/#admin-export](http://businessdirectoryplugin.com/docs/#admin-export)
 * And here:
    [http://businessdirectoryplugin.com/docs/#admin-import](http://businessdirectoryplugin.com/docs/#admin-import)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL Update – Website URL’ is closed to new replies.

 * ![](https://ps.w.org/business-directory-plugin/assets/icon-256x256.png?rev=2901888)
 * [Business Directory Plugin - Easy Listing Directories for WordPress](https://wordpress.org/plugins/business-directory-plugin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/business-directory-plugin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/business-directory-plugin/)
 * [Active Topics](https://wordpress.org/support/plugin/business-directory-plugin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/business-directory-plugin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/business-directory-plugin/reviews/)

## Tags

 * [url](https://wordpress.org/support/topic-tag/url/)

 * 3 replies
 * 2 participants
 * Last reply from: [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/sql-update-website-url/#post-6988322)
 * Status: resolved