Escaping Characters in PHP and MySQL

[DonP]

I'm having trouble with a very simple SQL statement to find a certain string within a body of text:

SELECT ID FROM mainpages WHERE BodyText LIKE [COLOR=red]'%<!--ImageBegin->%'[/color] AND ID = 10

No matter how I escape the characters in it, it isn't found even though it's there. Any ideas?

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases

 

[DonP]

This seems to have done the trick:

SELECT ID FROM mainpages WHERE BodyText LIKE [COLOR=green]'%" . mysql_real_escape_string('<!--ImageBegin-->') . "%'[/color] AND ID = 10

Don

http://www.pc-homepage.com/

http://www.personalzone.net/

Experienced in HTML, Perl, PHP, VBScript, PWS, IIS and Apache and MS-Access, MS-SQL, MySQL databases