Hi Please advise .. Im using stock standard FC3 install no updates or customisation to the my.cnf outher than the adding of trasaction logging.. My data is stored in mediumtext field , with 532 php and html web pages, for example. mysql> UPDATE temp.temp SET file_content = REPLACE(file_content,'.gif','.giff'); Query OK, 472 rows affected (0.79 sec) Rows matched: 532 Changed: 472 Warnings: 0 What causes the discrepancy between 472 rows affected and Rows matched: 532 and i'm getting this with all of my UPDATE quieries in some cases 0 rows affected and Rows matched: 532, but i know that the string im replacing is correct .. Gregory Machin greg@xxxxxxxxxxxxxx gregory.machin@xxxxxxxxx www.linuxpro.co.za Web Hosting Solutions Scalable Linux Solutions www.iberry.info (support and admin) www.goeducation (support and admin) +27 72 524 8096
