Search logics explained

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
OR
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
OR with exact word matches
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
AND
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
AND with exact word matches
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

Search logic

Advanced Options

Last updated 8 months ago

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