Staff List Search – Text Search

WordPress Plugin Staff List Search – Text Search

How a Text Search Works

Text search uses a LIKE expressions and wildcard characters where the percent sign (%) matches zero or more characters. Searching is case-insensitive.
For example, searching for mor creates SQL statement
WHERE FieldValue LIKE '%mor%'
and finds any values that have mor in any position.
  • more
  • moral
  • humor
  • glamor
  • remorse
  • Memory, and so on.
Wildcard searches provide a flexible mechanism for searching for words or phrases that match a given pattern.

Text Search – Single Field

Text Search – Multi Fields

  • A textbox filter for searching content of multiple fields.
  • Up to six fields can be searched for matches.
  • Field queries use OR operator. Output matches any of the specified fields.