Title: SQL field column? REPLACE urls
Last modified: August 22, 2016

---

# SQL field column? REPLACE urls

 *  [Neilisin](https://wordpress.org/support/users/neilisin/)
 * (@neilisin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/sql-field-column-replace-urls/)
 * Currently migrating and changed URL from test to live, and the main reason for
   using this plugin was for internal links.
 * I can’t locate where the URLS are being stored for me to run a REPLACE on it.
 * Please advise. 🙂
 * [https://wordpress.org/plugins/page-links-to/](https://wordpress.org/plugins/page-links-to/)

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

 *  Thread Starter [Neilisin](https://wordpress.org/support/users/neilisin/)
 * (@neilisin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/sql-field-column-replace-urls/#post-5918902)
 * Found it for those interested:
 * >  UPDATE `wp_postmeta` SET `meta_value` = REPLACE(`meta_value`, ‘old_url’, ‘
   > new_url’) WHERE `meta_value` LIKE ‘old_url’
 *  Thread Starter [Neilisin](https://wordpress.org/support/users/neilisin/)
 * (@neilisin)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/sql-field-column-replace-urls/#post-5918903)
 * You may wish to put backticks on the sql table and column names. 🙂

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

The topic ‘SQL field column? REPLACE urls’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/page-links-to_fafafa.svg)
 * [Page Links To](https://wordpress.org/plugins/page-links-to/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/page-links-to/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/page-links-to/)
 * [Active Topics](https://wordpress.org/support/plugin/page-links-to/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/page-links-to/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/page-links-to/reviews/)

 * 2 replies
 * 1 participant
 * Last reply from: [Neilisin](https://wordpress.org/support/users/neilisin/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/sql-field-column-replace-urls/#post-5918903)
 * Status: not resolved