Am trying to sort a found set after when search string has been found in first field and then in a second field. Example: when searching for "filemaker" the result should be sorted by "found in current_employer" first and then "found in previus_employer" after. How could this be done?
The search is working as expected, but not the sort.
my search script has one sort records at the end where I sort by current_employer ASC and previus_employer ASC. and that does almost do the job but some record show up at the bottom where the current_employer="filemaker"