SQL RegEx to remove a couple of lines from posts

Discussion in 'Programming' started by Boris_Badenoff, Dec 9, 2013.

  1. #1
    Hello Folks,

    Wondering if there is an expert out there that can help me with a SQL Regex I would like to set up to remove a row from a table in multiple posts. This is a Wordpress site so a SQL Server db, and I only want to run this for a category. I want to search and delete on the following string:
    "<tr>
    <td valign="top"><strong>Description:"

    and delete until it finds the first </tr>

    Any help would be greatly appreciated!
    Thanks for reading.
     
    Boris_Badenoff, Dec 9, 2013 IP
  2. bearthis

    bearthis Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #2
    think it will be easier to do it via PHP script that will do it and update the database
     
    bearthis, Dec 11, 2013 IP
  3. evtimii

    evtimii Active Member

    Messages:
    55
    Likes Received:
    9
    Best Answers:
    1
    Trophy Points:
    70
    #3
    evtimii, Dec 14, 2013 IP