cannot get the value

[robert_gsfame]

let say i have this

 

=================

mycolumn

=================

carrot, apple & orange

 

and i try this

$query=mysql_query("SELECT * FROM table WHERE mycolumn='carrot, apple & orange'");

$numrow=mysql_num_rows($query);

echo $numrow;

 

why do i always get 0 instead of 1 ??

I guess something caused by the comma there. How to fix it anyway?

[Pikachu2000]

There's probably leading/trailing whitespace in your data.