title: Oracle Query to delete all those records for which one column contains a specific string
body: <p>I am new to oracle and I am using toad.</p>
  
  <p>I want to delete all those records, one particular column(U_MSG) contains <code>", CALL HELPDESK"</code></p>
  
  <p>The column U_MSG is having 'bla bla foo abcd xyz lmn   ,CALL HELPDESK '</p>
  
  <p>I Tried like this :</p>
  
  <pre><code>Delete * from mytable where U_MSG = '% ', CALL HELPDESK'
  </code></pre>
  
  <p>But not getting the resuls though. Any Ideas?</p>
  
  <p>Also 2) How to delete that ,. I want to put space in place of ,.</p>
  
  <p>I tried this one</p>
  
  <pre><code>UPDATE Mytable t
     SET column = REPLACE(t.U_MSG, ''%, CALL HELPDESK'', '% CALL HELPDESK')
  </code></pre>