How to get result Sort by best match

Question

i have some resumes data in database i want retrieve those resumes by like operation. i search for a keyword in database if any resume contain that specific keyword multiple times that must be come on first. if i use like operation i got the result sort by date. i want sort by multiple match or best matches

Answer 1

try regexp_count(gives count of occurrence of a string) or text search. these are available in Oracle. you might have similar functionality in MySQL