From: Hank
Date: March 8 2012 9:11pm
Subject: preg_replace in update statement
List-Archive: http://lists.mysql.com/mysql/226941
Message-Id: <CAPs4VGncVXXd3SX_J2yMSR_Yf88zLsrmY64Ccxt+sjeM-hDiHg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

I have a simple problem:

I have a varchar field in the database, and I want to remove all text
between WordA and WordB, including WordA and WordB, leaving all text
before WordA and after WordB intact.

Possible with just SQL?  I know I can write a PHP program to do it,
but it's not that important to spend that much time on.  I'd like one
SQL statement to do it.

Thanks!

-Hank