title: Replace everything before the last '/' that contains a special website in one column
body: <p>I have a table with logo column, it contains urls to logos of companies from different websites. I have parsed logos from a website that has the greatest number of logos and now can't update urls to my local adress. </p>
  
  <p>For example, a URL is:</p>
  
  <pre><code>http://logo-website.com/77/13/20/company-logo.png
  </code></pre>
  
  <p>I want to replace everything before the last / and add <code>images/logo/</code>
  Eventually, it should look: <code>images/logo/company-logo.png</code>.    </p>
  
  <p>The update should be applied only to urls that contain <code>'logo-website.com'</code></p>
  
  <p>This is my example, it seems to me I managed to get only %logo-website% rows but can't evrything replace before last '/'</p>
  
  <pre><code>UPDATE `companies` 
  SET `Logo` = 'images/logo/' + SUBSTRING_INDEX(`Logo`, '//', 1)
  WHERE name LIKE '%logo-website%'
  </code></pre>