title: MySQL String replacement with multiple values?
body: <pre><code>    ClosedAccount[TABLE] values .
  
      |---------SERVICES-------------|
  
      ACCOUNTS,DOCS,BOOKS,READER
      BOOKS,ACCOUTNS,CALENDAR,READER
  </code></pre>
  
  <p>QUERY</p>
  
  <p>I Want to exclude "ACCOUNTS,BOOKS,READER" from two rows . This order is not properly maintained .</p>
  
  <p>Trivial Solution :</p>
  
  <p>Select REPLACE(REPLACE(replace(services,"ACCOUNTS",""),"DOCS",""),"READER","") from  ClosedAccount;</p>
  
  <p>I want to optmize this . Is there any solution avialable please suggest .</p>