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 stef...@execuchoice.net Phoenix, Az http://www.ExecuChoice.net USA AIM : SteffanC ICQ : 57234309 YAHOO : Steffan_Cline MSN : stef...@hldns.com GOOGLE: Steffan.Cline Lasso Partner Alliance Member --------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org