> 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:
http://www.mysql.com/doc/S/t/String_functions.html
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
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]