Community Builder Advanced Search - Help Section

You are able to add more Operators.

There are currently two sql operators. These are

  1. Logical Operators
  2. Comparison Operators

Logical Operators

We have tried and have added all the logical operators which we think are necessary to run the search component.  If you need to add a new one, please check the mysql help file to get the correct syntacs.

Comparison Operators

We also tried here to add all relevant comparison operators.  To add some more you need to follow the following code:

'sqlcodeSEARCHWORDsqlcode'

Explanation: