Re: Quotation marks in string causing repace to not work.

[Ludwig Pummer]

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");?>', '');