You may find this helpful: http://www.mysqludf.org/lib_mysqludf_preg/
On Thu, Mar 8, 2012 at 4:11 PM, Hank <heskin@stripped> wrote:
> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
Percona Inc <http://www.percona.com/>
Consulting, Training, Support & Services for MySQL