{"id":862566,"date":"2008-09-20T01:09:54","date_gmt":"2008-09-20T01:09:54","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-querry-help-replace-certain-words-in-every-post\/"},"modified":"2016-08-19T02:22:23","modified_gmt":"2016-08-19T02:22:23","slug":"sql-querry-help-replace-certain-words-in-every-post","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-querry-help-replace-certain-words-in-every-post\/","title":{"rendered":"SQL querry help – replace certain words in every post"},"content":{"rendered":"

Hi,<\/p>\n

I recently moved to a linux server as a result of which all my image filenames are now suddenly lowercase. I did not envision this before, so now I have to rename each instance “JPG” with “jpg” and “IMG” with “img” – across all my posts.<\/p>\n

Since I have to make this change anyway, I also thought of modifying the image gallery address from say “gallery\/set1” to “gallery\/category1\/set1”<\/p>\n

Can anyone help me with SQL query to make such blog-wide change? I have no programming experience but I can read and play with the querries to suit.<\/p>\n

Thanks in advance,
\nPriyank<\/p>\n","protected":false},"template":"","class_list":["post-862566","topic","type-topic","status-closed","hentry","topic-tag-mysql"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/862566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/862566\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=862566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}