in reply to Re: Re: [OT] Weighted Search Results
in thread [OT] Weighted Search Results

This worked like an absolute champ! What a wonderful day this has turned out to be! As was noted by a colleague of mine, this of course coudl slow down dramatically for large datasets since the having is an unindexed column and woudl require some shuffling by MySQL in the background.


CiceroLove
Fates! We will know your pleasures: That we shall die, we know; 'Tis but the time, and drawing days out, that men stand upon. - Act III,I, Julius Caesar
  • Comment on Re: Re: Re: [OT] Weighted Search Results

Replies are listed 'Best First'.
Re: Re: Re: Re: [OT] Weighted Search Results
by eric256 (Parson) on May 20, 2004 at 17:56 UTC
    For larger cases you could break it into to parts. First get all records that have at least one matching feild. Then go threw those and score them. You could use a temp table or nested select statments.

    ___________
    Eric Hodges