cool ! that's what i wanted to say :)
thank jason wong !
u da best

--- "Jason Wong" <[EMAIL PROTECTED]>
> wrote:
>> no it's working (successed), but nothing was updated.
>> I tried to make a fake table.
>> when i tried to make a fake table its working.
>> i tried to change "ABC" from the table to "XXX"
>> but if i got data called ABCD , it didnt change to XXXD
>> why ?
>*Now* I know what you're trying to do. The UPDATE query given previously:
>UPDATE table set field='XXX' WHERE field='YYY'
>competely replaces the *whole* field.
>What you want is something that replaces *part* of the field. Off hand I
>can't think of a way to use a single SQL query to do what you want. You may
>want to look at the string functions of MySql to see whether they will help:
>Jason Wong
>Gremlins Associates
>Tel: +852-2573-5033
>Fax: +852-2573-5851

_____________________________________________________________ - FREE EMAIL SERVICE

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to