Each logic behaves differently. Please check the practical examples on this page to understand how they work.
The tables below present the major logical difference between the Regular (default) and the Index table engine:
The regular engine cannot use the logic across separate fields for each keyword (title, content, excerpt etc..)
The Index table engine can
Match is found if any of the search keywords is part of the content. It's the least strict of all possible options - it returns many results, finds almost anything.
Keyword | Fields | Match with Regular engine? (default) | Match with Index table engine? |
hello | Post Title: Hello big world! Post Content: Robot here! | YES | YES |
hello wor | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
hello robot | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
hel bot | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
help bot hello | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
hello science | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
Similar to the simple OR, but at least one keyword must match a whole word. Partial results are not accepted.
​
Keyword | Fields | Match with Regular engine? (default) | Match with Index table engine? |
hello | Post Title: Hello big world! Post Content: Robot here! | YES | YES |
hello wor | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
hello robot | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
hel bot | Post Title: Hello big world! ​ Post Content: Robot here! | NO (whole word don't match) | NO (whole word don't match) |
help bot hello | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
hello science | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
Every keyword must match at least partially the content.
Keyword | Fields | Match with Regular engine? (default) | Match with Index table engine? |
hello | Post Title: Hello big world! Post Content: Robot here! | YES | YES |
hello wor | Post Title: Hello big world! ​ Post Content: Robot here! | YES | YES |
hello robot | Post Title: Hello big world! ​ Post Content: Robot here! | NO | YES |
hel bot | Post Title: Hello big world! ​ Post Content: Robot here! | NO | YES |
help bot hello | Post Title: Hello big world! ​ Post Content: Robot here! | NO | NO |
hello science | Post Title: Hello big world! ​ Post Content: Robot here! | NO | NO |
The most strict search logic. Every keyword must match a whole word in the content.
Keyword | Fields | Match with Regular engine? (default) | Match with Index table engine? |
hello | Post Title: Hello big world! Post Content: Robot here! | YES | YES |
hello wor | Post Title: Hello big world! ​ Post Content: Robot here! | NO | NO |
hello robot | Post Title: Hello big world! ​ Post Content: Robot here! | NO | YES |
hel bot | Post Title: Hello big world! ​ Post Content: Robot here! | NO | NO |
help bot hello | Post Title: Hello big world! ​ Post Content: Robot here! | NO | NO |
hello science | Post Title: Hello big world! ​ Post Content: Robot here! | NO | NO |