Hi GEORGE,
> The typical way refers to the update syntax. Ideally,
> I would like to be able to do something like that:
> - read the value of the variable through a read
> statement.
> -Specify the value to be appended.
> -Do the task.
>
> Could you please help me out with that?
> > > I would li
Hi GEORGE,
> I would like to ask a simple question about the way
> MySQL handles string variabels. Say i have a variable
> whose value is foo and I want to change it to foobar.
>
> Instead of doing it the 'typical' way, I would like to
> ask whether there is any mysql command that will allow
>
The REPLACE command may be what you're asking about.
SELECT REPLACE('This is a foo','foo','foobar');
will return "This is a foobar".
SELECT REPLACE(city,'Denver','Albuquerque') from foo;
In table "foo", every occurrence of "Denver" in column "city" is replaced by
"Albuquerque".
Regards,
Dou
At 1:25 + 3/15/02, GEORGE KONSTANTINOY LEKEAS wrote:
>Hi All,
>
>I would like to ask a simple question about the way
>MySQL handles string variabels. Say i have a variable
>whose value is foo and I want to change it to foobar.
>
>Instead of doing it the 'typical' way, I would like to
>ask whet
Hi All,
I would like to ask a simple question about the way
MySQL handles string variabels. Say i have a variable
whose value is foo and I want to change it to foobar.
Instead of doing it the 'typical' way, I would like to
ask whether there is any mysql command that will allow
me to say read th