07-14-2008, 08:29 AM
|
#2 (permalink)
|
|
The Prestige
Join Date: Oct 2007
Location: Manchester, UK
Posts: 854
Thanks: 32
|
try wrapping the elements test in a <![CDATA[ ]]> tag, because xml elements can have sub elements the parser will look inside your phrase element for '<' then interpret them as XML, CDATA tells the parser to ignore it.
XML CDATA
__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)
|
|
|
|