Hi All

I'm doing search in a table and need results to be ordered based on which column keyword is found in.
For example I have a table that contains artist anme and bio. I want to perform search so if keyword is found in ArtistName results will appear higher that when it's found in the bio.

here is the query I came up with:
select artistname,bio from artist
where contains(artistname,'isabout (John weight (0.8))') or contains (bio,'isabout (John weight (0.5))')

How do I order it by rank? Also is it possible to get results that contain both higher than if it only contains one. Do I have to add another condition like
or (contains (bio,'isabout (John weight (0.5))')) AND (contains(artistname,'isabout (John weight (0.8))')) ) ?

Best regards,