Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Re: Re: [OT] Weighted Search Results

by CiceroLove (Monk)
on May 20, 2004 at 17:36 UTC ( #355029=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://355029]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2021-06-25 04:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What does the "s" stand for in "perls"? (Whence perls)












    Results (133 votes). Check out past polls.

    Notices?