Hi Please could you advise. I inserted some web pages into a table and now i need to do updates to the pages so that the cms can display them with out the legacy code. there are about 1000 pages.
I tried the following UPDATE temp SET 'file_content' = REPLACE(file_content, '<?php require($_SERVER['DOCUMENT_ROOT']."/scripts/define_access.php");?>' , ''); but it didn't work, i think thing problem is that the string i need to replace / null has quotation marks .. how can i work around this .... Many Thanks -- Gregory Machin [EMAIL PROTECTED] [EMAIL PROTECTED] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]