Prioritize catsearch results
Does anyone have a clever way to prioritize (order) the result set of a catsearch query such that the "best" matches rise to the top? For example, I'm querying a large table of street names using SELECT st_name as name FROM street_names WHERE catsearch(st_name, 'Oak St', null) > 0;
This results in 87 matches, with "Oak St" (the one I'm most likely looking for) no better than the 50th row in the result set. Since it is an exact match, I'd like it to be the first row, with other variations in decreasing order of "matchiness". Any suggestions appreciated.