> 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

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]

Reply via email to