Re: preg_replace in update statement

2012-03-08 Thread Hank
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 wrote: > If your words need to be regular expressio

Re: does the number of column affect performance

2012-03-08 Thread Zheng Li
sorry for the duplicate message. just ignore it. On 2012/03/09, at 10:11, Zheng Li wrote: > > what if I have to select all columns every time? > any difference in performance? > > On 2012/02/29, at 4:41, Paul DuBois wrote: > >> >> On Feb 28, 2012, at 9:59 AM, Zheng Li wrote: >> >>> for exam

Re: does the number of column affect performance

2012-03-08 Thread Zheng Li
what if I have to select all columns every time? any difference in performance? On 2012/02/29, at 4:41, Paul DuBois wrote: > > On Feb 28, 2012, at 9:59 AM, Zheng Li wrote: > >> for example >> there are 2 tables to save same data >> table A has 10 columns: a primary key column and 9 blob column

preg_replace in update statement

2012-03-08 Thread Hank
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