Hello everybody,

I'm trying to set up a small search method for my database,
I've followed the instructions at mysql.com about fulltext indexs etc.

now this line works

select * form data where match (name,town,area) against ("north");

however this line doesn't

select * form data where match (name,town,area) against ("nor*");

Anyone got any ideas? or know of a easier way of searhing a mysql db?

Cheers

Resis