Sort according to value match

I want to sort data according to condition if particular column value match with query value then that record should come first after that record with unmatched value should come, for example when I search for "Sydney, New South Wales, Australia" then record having "Sydney" in their city field should come first then other cities record like "Melbourne", "Adelaide" should come in Australia.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.