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.

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