is tha way how to fulltext search in JSON MVA? I have indexed tag/keywords and i want in result only exact results.
example:
cast
- list of all actors, but as text - sql_attr_string
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"Joe Reeves"
-
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?