As described earlier in the tutorial, one of the goals of search and query in Redis Stack is to provide rich querying capabilities such as:
The best way to start to work with Redis Stack query capabilities is to look at the various conditions options.
> FT.SEARCH "idx:movie" "heat" RETURN 2 title plot
1) (integer) 4
2) "movie:1141"
3) 1) "title"
2) "Heat"
3) "plot"
4) "A group of professional bank robbers start to feel the heat from police when they unknowingly leave a clue at their latest heist."
4) "movie:818"
5) 1) "title"
2) "California Heat"
3) "plot"
4) "A lifeguard bets he can be true to just one woman."
6) "movie:736"
7) 1) "title"
2) "Chicago Justice"
3) "plot"
4) "The State's Attorney's dedicated team of prosecutors and investigators navigates heated city politics and controversy head-on,while fearlessly pursuing justice."
8) "movie:1109"
9) 1) "title"
2) "Love & Hip Hop: Miami"
3) "plot"
4) "'Love and Hip Hop Miami' turns up the heat and doesn't hold back in making the 305 the place to be. Multi-platinum selling hip-hop legend Trick Daddy is back in the studio collaborating ..."
The first line contains the number of documents (4) that match the query condition, then the list of movies.
This query is a "fieldless" condition, this means that the query engine has:
title and plot)heat and related words, this is why the movie:736 is returned since it has the word heated in the plot (stemming)In this case you have to set the criteria to a the field title using the @title notation.
> FT.SEARCH "idx:movie" "@title:heat" RETURN 2 title plot
1) (integer) 2
2) "movie:1141"
3) 1) "title"
2) "Heat"
3) "plot"
4) "A group of professional bank robbers start to feel the heat from police when they unknowingly leave a clue at their latest heist."
4) "movie:818"
5) 1) "title"
2) "California Heat"
3) "plot"
4) "A lifeguard bets he can be true to just one woman."
So only 2 movies are returned.
For this you add parentheses around the field condition and add the - sign to 'california'.
> FT.SEARCH "idx:movie" "@title:(heat -california)" RETURN 2 title plot
1) (integer) 1
2) "movie:1141"
3) 1) "title"
2) "Heat"
3) "plot"
4) "A group of professional bank robbers start to feel the heat from police when they unknowingly leave a clue at their latest heist."
Only one movie is returned.
If you do not put the ( .. ) the -california condition will be applied to all the text fields.
You can do test this with the following queries:
> FT.SEARCH "idx:movie" "@title:(heat -woman)" RETURN 2 title plot> FT.SEARCH "idx:movie" "@title:heat -woman" RETURN 2 title plotAs you can see the first query only searches for woman in the title and returns two movies "Heat" and "California Heat", where the second query eliminates "California Heat" from the list since the plot contains the word woman.
