SQL field column? REPLACE urls

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Neilisin

    (@neilisin)

    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

    (@neilisin)

    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.