[Resolved] MySQL full text queeries

[Davidc316]

I've been experimenting with MySQL and it turns out that if I do a basic mysql search of the format:

SELECT * FROM tablename WHERE MATCH(name, type, description) AGAINST ("searchword");

...then it can only handle up to ten results.

If there are ANY MORE than ten valid results then the search will display the result 'Empty Set'.

Folks, this is not some bizzare and awkward piece of script I'm using here. Please do not dismiss me as some guy with a weird and unique piece of code. I'm using the basic full text search command that's recommended in the MySQL manual and elsewhere!!!

What's going on here?????????

[Davidc316]

INSPIRATION!!!!!!

It just hit me!!!

When I was adding the extra record, suddenly more than 50% of the rows delivered a valid result.

MySQL of course, doesn't count such overwhelmind results as valid so it's sending back a message that zero rows were returned.

I haven't even tested this theory yet, but I know I'm right.

I'll leave this thread up in an attempt to stop anyone else from going through 2 days of hell like I did.