List:General Discussion« Previous MessageNext Message »
From:Steffan A. Cline Date:August 12 2009 6:48pm
Subject:MySQL and Relevance
View as plain text  
Anyone know of a way to do a query within MySQL kind of like a relevance but
without  the Full Text index?

I am searching on country, region and city. Now, that's easy enough but what
if I need to sort by full match down to partial and no matches but always
get something like always a found set of 5 regardless?

The country is searched as a 2 letter ANSI code and the region and city are
searched as plain varchar fields.

Any suggestions are welcome.


Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 7 9 3 . 0 0 1 4 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline  
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
YAHOO : Steffan_Cline   MSN : steffan@stripped
GOOGLE: Steffan.Cline             Lasso Partner Alliance Member
---------------------------------------------------------------



Thread
MySQL and RelevanceSteffan A. Cline12 Aug