Re: why can not pass constant to stored procedure?

2012-03-10 Thread Antony T Curtis
On 10 Mar, 2012, at 7:06 pm, Cifer Lee wrote: > when we call procedure > normally we declare the parameter out of the procedure and pass the > variable to procedure > like this > > set @x=1; > call *a_procedure*(@x); > > why can not directly pass the digit 1 to the* a_procedure* ? You can pa

Re: preg_replace in update statement

2012-03-10 Thread Hal�sz S�ndor
2012/03/08 16:11 -0500, Hank 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 th