cool ! that's what i wanted to say :)
thank jason wong !
u da best
--- "Jason Wong" <[EMAIL PROTECTED]>
>> 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:
www.kaskus.com - FREE EMAIL SERVICE
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]