They are regular words. I was hoping someone would already know how to do it. I was trying to avoid rolling my own solution using the string functions. It gets really messy, really quick.
-Hank On Thu, Mar 8, 2012 at 8:18 PM, Michael Dykman <mdyk...@gmail.com> wrote: > If your words need to be regular expressions, per-se with meta > characters, etc.. Â you are pretty much out of luck. Â If you only need > to match some literal strings, a method can surely be derived through > the heavy-handed use of mysql's string function library. > > http://dev.mysql.com/doc/refman/5.0/en/string-functions.html > > Â - michael dykman > > 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 >> > > > > -- > Â - michael dykman > Â - mdyk...@gmail.com > > Â May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql