This is a read-only copy of the MariaDB Knowledgebase generated on 2024-04-29. For the latest, interactive version please visit https://mariadb.com/kb/.

Knowledge Base Search Operators

The following special operators can be used when searching the Knowledge Base:

Search Operators

  • operator OR:
    hello | world
    
  • operator NOT:
    hello -world
    
    • You can also use:
      hello !world
      
  • field search operator:
    @title hello @answer world
    
  • field position limit modifier:
    @answer[50] hello
    
  • multiple-field search operator:
    @(title,answer) hello world
    
  • all-field search operator:
    @* hello
    
  • phrase search operator:
    "hello world"
    
  • proximity search operator:
    "hello world"~10
    
  • quorum matching operator:
    "the world is a wonderful place"/3
    
  • strict order operator (aka operator "before"):
    aaa << bbb << ccc
    
  • exact form modifier:
    raining =cats and =dogs
    
  • field-start and field-end modifier:
    ^hello world$
    

Here's an example query that uses some of the above operators:

"hello world" @title "example program"~5 @answer python -(php|perl) @* code

Field Names

Valid field names include:

  • title
  • answer
  • question
  • node_id
  • user_id
  • type
  • type_crc
  • status
  • status_crc
  • answered
  • created
  • modified
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.