I have a market products dataset. My query is “chocolate”, some of the first records returned are (A):
WAFER RENATA CHOCOLATE MOUSSE 115gr.
WAFER CON RELLENO DE CHOCOLATE RENATA 115 GR
WAFER CHOCOLATE ISABELA 145G
VASO DE CAFÉ INCLUCYE MEZCLA PARA CHOCOLATE
VALLE CANOABO CHOCOLATE 90% 50G
VALLE CANOABO CHOCOLATE 80% 50G
TURRON DE CHOCOLATE LA MARCONA 150 GR
TRUFFAS DE CHOCOLATE ST.MORITZ 8 UDS
TORTA MARMOLEADA DE CHOCOLATE 450GR
TORTA de CHOCOLATE RENATA TRADICIONAL 250GR
And in the dataset I have other records such as (B):
CHOCOLATE VALLE CANOABO SAL MARINA 50 GR.
CHOCOLATE VALLE CANOABO GALLETA Y CREMA 50 GR.
The problem is that the A records are being ranked way before the B ones, and what I want is to get records with the word “chocolate” placed as early as possible to be ranked before those that have it placed subsequently, something like:
CHOCOLATE word word
word CHOCOLATE word
word word CHOCOLATE
Thanks in advance.