Newbie Help with true Fulltext search

[Edcrosbys]

Okay, I'm new to databases!!! I've made an asp page that points to an mysql database. Here is part of the database structure:

DB: MikeShop
Table: Jobs
Field: Description varchar(255)
(along with other fields)

I have also built a fulltext index on this field.

If I do a search like this:

Select * from jobs where match (description) against ('%%wes%%');

I will not return the descriptiona with the word west in them.
If I change it to:

Select * from jobs where match (description) against ('%%west%%');

It will. Can someone please help?

Thanks Alot,
Eric

 

[piti]

u don't need those % in the query when using fulltext search as u need them in the LIKE statement
it's just: match (description) against ('wes')
should be working