Hello, I have a 'videos' table with 3 fields 'name', 'description' and 'categories'. When doing a search I want to appear at the top videos that in the 'name' have more of these keywords, for example if I search "beautiful house" a video with name 'CASA in Alagoas BONITA' has to stay more on top than a video with name "sao paulo CASA" and description "look how beautiful it is" (because I do the research looking for the key words in name and description).
Does anyone have an idea how to do this?