Is there any Filtering query in Mysql to sorty by relevance?

15
January 13, 2019, at 05:10 AM

Is there any way to write a filtering query for the following scenario in mysql

1:I've a mysql table which four fields(SongLink,Artist,Song Title,Album). When the user searches a song through a combinatoin search words(ArtistTitleAlbum) it should sort the values and show the most relevant contents on top.

Scenario 1:For eg. If I search AR Rahmman JaiHo it should list Jai Ho ablum at top 2:If I search Jai Ho Slum Dog millionare, it should list Jai Ho at top 3: IF I search Slum Dog Millionare Jai Ho , it should list Jai Ho at top.

Challenge: The current challenge is when I try to filter it using Like or against, it is listing all the other values in top. For eg. for the first sitaution, Intead of Jai ho the other album with Rahman is listing on top.

Any suggestions or links pointing to help wil be truly appreciated. Thanks for the help?

READ ALSO
Database design for B2B2C system

Database design for B2B2C system

I want to create an application, where my direct clients are business personThey would use the application to make transactions with their customers

14
i can't get the following $resultCheck to redirect

i can't get the following $resultCheck to redirect

I have the following code and it is displaying the select tag options as $level1promo_competition based on what is in my databaseThe thing that is puzzing me is that if I changed the name in my database or my variable to something else other than what is in my database,...

29
how to call json with and without data [on hold]

how to call json with and without data [on hold]

i tried to make a json from php and want it can be get with data like http://localhost/moviereview/?action=get_review&genre=biography and or without data like http://localhost/moviereview/?action=get_review

20
Image from database is not appearing on the .jsp page [on hold]

Image from database is not appearing on the .jsp page [on hold]

The screenshot below shows my web page that is not showing the imageCan someone see why that might be

14