Search logics explained

Last updated 2 months ago

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..)

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