From: Steffan A. Cline Date: August 12 2009 6:48pm Subject: MySQL and Relevance List-Archive: http://lists.mysql.com/mysql/218397 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 ---------------------------------------------------------------