SET @book_id = ; SET @old_url = "http://url/of/the/old/book"; SET @new_url = "http://url/of/the/new/book"; -- UPDATE scalar_db_versions INNER JOIN scalar_db_content ON scalar_db_versions.content_id = scalar_db_content.content_id AND scalar_db_content.book_id = @book_id SET scalar_db_versions.url = REPLACE(scalar_db_versions.url, @old_url, @new_url), scalar_db_versions.content = REPLACE(scalar_db_versions.content, @old_url, @new_url); -- UPDATE scalar_db_content SET scalar_db_content.background = REPLACE(scalar_db_content.background, @old_url, @new_url), scalar_db_content.banner = REPLACE(scalar_db_content.banner, @old_url, @new_url), scalar_db_content.thumbnail = REPLACE(scalar_db_content.thumbnail, @old_url, @new_url) WHERE scalar_db_content.book_id = @book_id;