Topic awaiting preservation: Sorting a MySQL multi-table SELECT query by relevancy |
|
---|---|
Author | Thread |
Bipolar (III) Inmate From: f(x) |
posted 12-31-2004 04:13 |
Bipolar (III) Inmate From: f(x) |
posted 12-31-2004 22:06 |
Paranoid (IV) Inmate From: Madison, Indiana, USA |
posted 01-01-2005 17:22 |
Bipolar (III) Inmate From: f(x) |
posted 01-02-2005 01:50
Well, I almost have what I want. code: SELECT _test_items . * , _test_stores.name AS storen,
|
Paranoid (IV) Inmate From: France |
posted 01-02-2005 02:10
I've never used the MATCH clause in SQL, by my first guess is that if the MATCH clause fed by a single word, whatever its size, works then you can build a query like : |
Bipolar (III) Inmate From: f(x) |
posted 01-02-2005 05:58
I don't know if you're seeing what I'm getting at. MATCH ignores words 3 characters or less, this leaves a issue with words like red. For those words, I use LIKE which recognizes the small words. quote: |
Paranoid (IV) Mad Scientist with Finglongers From: Germany |
posted 01-02-2005 17:24
you'll have no luck with 3 word search terms and mysql - unless you change the source and compile yourself. |
Bipolar (III) Inmate From: f(x) |
posted 01-02-2005 19:34
Well, since there's no way around this problem I'm having, I'll have PHP look at the search query given and sort be relevancy whenever possible. The word red is a heavily used word in searches preformed. About 73 (5.7%) of all 1270 searches thus far contained the word red, 27 (2.1%) searches were red alone. So it's not a rare sight for what I need it for. |
Paranoid (IV) Mad Scientist with Finglongers From: Germany |
posted 01-02-2005 20:42
well, I just found out, you can actually reconfigure mysql (4.0.0 +) to consider words <3 letters in your searches. |
Bipolar (III) Inmate From: f(x) |
posted 01-03-2005 11:29 |