title: MySQL - Remove substring from an entry
body: <p>My 'Location' table contains 6 columns. (ID, Name, Alias, Area, X, Y)</p>
  
  <p>Example of some entries from the 'Name' column:</p>
  
  <pre><code>Blackwood Highschool, Paris, France
  
  Hilltop Market, Barcelona, Spain
  
  Roundwell Plaza, Melbourne, Australia
  
  Rurk Mount, Moscow, Russia(mountain)
  
  History Museum, Prague, Czech Republic
  
  Narrow River (river), Bombay, India
  </code></pre>
  
  <p>Some entries include "(mountain)", "(river)" or "(...)" within the name (8 different ones). I don't know why the table was created this way. It should have had an extra column for this data, but well.</p>
  
  <p>I want to remove just the "(...)" substrings from the Location Names. I don't know how to do it, it's something like this so you get an idea:</p>
  
  <pre><code>DELETE FROM 'Location' 
  WHERE 'Name'
  LIKE '%(%)%';
  </code></pre>
  
  <p>I know this would delete the whole row, but I just want to remove the (%) term from the 'Name' string.</p>