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