Mysql sigle word search problem

[BiGreat]

HI,
  I have a table which contain a  Field "word(varchar(50))" and the word contain two word "bill" "bill fill".

However, I use this mysql query "select * from table where word = 'bill' " but return nothing.

I don't know why?

Thanks

[Jocka]

so your saying it has 2 fields. One has the word bill and one has the words bill fill? your search should come up right. If that is all in one field then you should look into the mysql "LIKE" statement. Where your query would be something like:
"SELECT * FROM table WHERE word LIKE '%bill%'"