Gregory Machin wrote:
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 ....
You need to escape the quotation marks. Also, did you mean to write
'file_content', or `file_content` ?
Try
UPDATE temp SET `file_content` = REPLACE(file_content, '<?php
require($_SERVER[\'DOCUMENT_ROOT\']."/scripts/define_access.php");?>', '');
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
