MATCH - AGAINST query issue

[Aaron Whiffin]

Hi, I've set up the following table in MySQL 3.23.58 and all seemed to be
working fine:

CREATE TABLE advert (
id INT NOT NULL AUTO_INCREMENT,
userid INT NOT NULL,
make VARCHAR(25) NOT NULL,
model VARCHAR(15) NOT NULL,
year VARCHAR(4) NOT NULL,
price FLOAT(7,2) NOT NULL,
colour VARCHAR(20) NOT NULL,
description TEXT NOT NULL,
county VARCHAR(25) NOT NULL,
approval BIT,
end DATE,
PRIMARY KEY (id),
KEY (make,price),
FULLTEXT(make,model,year,colour,description,county )
);

.... I then added some cars from my PHP front end and started using the
following query:

SELECT * from advert, WHERE end >= CURDATE() AND approval ='1';

It worked

I then wanted to add a keyword search field (hence the FULLTEXT) so changed
by query to:

SELECT * from advert WHERE end >= CURDATE() AND approval ='1' AND MATCH
(make,model,year,colour,description,county) AGAINST ('keyword');

Here I started having problems, here is a sample description for one of my
(6) cars:

Metallic Blue Golf GTi. 153K Miles. FFSR. New exhaust. New front disks and
pads. Kenwood CD player. Detachable parchel shelf. Great car.

If I make the keyword '153k', 'disks', 'shelf', 'pads' etc it works. If
Imake it 'cd', 'front', 'car', 'gti' it doesn't

I have had a look through the other cars/descriptions and realised that the
words that don't work are those that appear elsewhere on different listings.

i.e. my query is unhappy producing more han one result

Can someone please explain why and how to fix this

Cheers

[Aaron Whiffin]

Can someone please explain why and how to fix this

After ages of looking at it I've just read something

My problem is a combination of two things

1. < 3 char searches
2. The 50% rule

Soz to waste your time ...

[Aaron Whiffin]

2. The 50% rule

Is there a way I can tell (via PHP) that no result was returned due to the
50% rule or due to their being no records that match the criteria?

Many thanks

[ScareCrowe]

Sorry I don't have an answer, I have a question! What's the 50% rule?
(sorry, semi-noob!)
--ScareCrowe
"Aaron Whiffin" <aa***@nospam.com> wrote in message
news:0K***************@newsfe2-gui.ntli.net...

2. The 50% rule

Is there a way I can tell (via PHP) that no result was returned due to the
50% rule or due to their being no records that match the criteria?

Many thanks

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Aaron Whiffin]

Sorry I don't have an answer, I have a question! What's the 50% rule?
(sorry, semi-noob!)

If a query produces a result set larger than 50% of the total data set then
it is displayed as empty (i.e. no results)

You can override this with IN BOOLEAN MODE but I'm using MySQL 3.23.58 which
doesn't support this.

So I need to know if an empty result set is empty of retruned as empty as
it's too large ....

[Aaron Whiffin]

Sorry I don't have an answer, I have a question! What's the 50% rule?
(sorry, semi-noob!)

If a query produces a result set larger than 50% of the total data set then
it is displayed as empty (i.e. no results)

You can override this with IN BOOLEAN MODE but I'm using MySQL 3.23.58 which
doesn't support this.

So I need to know if an empty result set is empty of retruned as empty as
it's too large ....

[Hans Christoffer Johansen]

Couldn't you write a similar query, just adding "LIMIT 1" or something, and
see if that is empty? If it is, then the other would be empty because of no
result, otherwise because the result set was too large...
"Aaron Whiffin" <aa***@nospam.com> skrev i melding
news:zM************@newsfe5-win.ntli.net...

Sorry I don't have an answer, I have a question! What's the 50% rule?
(sorry, semi-noob!)
If a query produces a result set larger than 50% of the total data set

then it is displayed as empty (i.e. no results)

You can override this with IN BOOLEAN MODE but I'm using MySQL 3.23.58 which doesn't support this.

So I need to know if an empty result set is empty of retruned as empty as
it's too large ....

[Hans Christoffer Johansen]

Couldn't you write a similar query, just adding "LIMIT 1" or something, and
see if that is empty? If it is, then the other would be empty because of no
result, otherwise because the result set was too large...
"Aaron Whiffin" <aa***@nospam.com> skrev i melding
news:zM************@newsfe5-win.ntli.net...

Sorry I don't have an answer, I have a question! What's the 50% rule?
(sorry, semi-noob!)
If a query produces a result set larger than 50% of the total data set

then it is displayed as empty (i.e. no results)

You can override this with IN BOOLEAN MODE but I'm using MySQL 3.23.58 which doesn't support this.

So I need to know if an empty result set is empty of retruned as empty as
it's too large ....

[ScareCrowe]

"Hans Christoffer Johansen" <os*******@hotmail.com> wrote in message
news:dD******************@news4.e.nsc.no...

Couldn't you write a similar query, just adding "LIMIT 1" or something, and see if that is empty? If it is, then the other would be empty because of no result, otherwise because the result set was too large...

Oh you wanna rematch huh?

Sounds like that would do the trick to me!


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[ScareCrowe]

"Hans Christoffer Johansen" <os*******@hotmail.com> wrote in message
news:dD******************@news4.e.nsc.no...

Couldn't you write a similar query, just adding "LIMIT 1" or something, and see if that is empty? If it is, then the other would be empty because of no result, otherwise because the result set was too large...

Oh you wanna rematch huh?

Sounds like that would do the trick to me!


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----