| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Hank | Date: | March 8 2012 9:11pm |
| Subject: | preg_replace in update statement | ||
| View as plain text | |||
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
| Thread | ||
|---|---|---|
| • preg_replace in update statement | Hank | 8 Mar |
| • Re: preg_replace in update statement | Baron Schwartz | 9 Mar |
| • RE: preg_replace in update statement | David Lerer | 9 Mar |
| • Re: preg_replace in update statement | hsv | 10 Mar |
| • Re: preg_replace in update statement | Hank | 9 Mar |
