is tha way how to fulltext search in JSON MVA? I have indexed tag/keywords and i want in result only exact results.
cast - list of all actors, but as text -
tag - is cast, but in JSON
sql_attr_json with data like:
["Keanu Reeves", "Laurence Fishburne", "Carrie-Anne Moss", "Hugo Weaving", "Gloria Foster", "Joe Pantoliano"]
when user is entered “Joe Reeves” and expression is:
WHERE match(@cast Joe Reeves)- result is false positive, because there is no actor with name
when user is entered “Reeves Keanu” expression is:
WHERE tag='Reeves Keanu' and match('@cast Reeves Keanu')- nothing is found, because name and surename is in wrong order
what is best way to search only
Keanu Reeves in cast?