RE: [PHP] Match Vs Where - Fulltext Search

2004-09-28 Thread Jay Blanchard
[snip] I know this post is lengthy and I apologise for putting you to sleep but I'd really love to get to the bottom of this one sometime soon. Has anyone else experienced similar frustrations searching their databases - I can't be the only one...! [/snip] What you are dealing with here, Michae

[PHP] Match Vs Where - Fulltext Search

2004-09-28 Thread Harlequin
Hi all. It took me some time to discover that you can't use a "MATCH | AGAINST" statement unless you create an fulltext index of the fields to search at the same time. Strange, I know. What's more strange is that as I read more I wonder why people use it because it will only seartch complete w