Community Builder Advanced Search - Help Section You are able to add more Operators. There are currently two sql operators. These are
Logical Operators 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:
' - the beginning needs to have this character sqlcode - the sql code SEARCHWORD - needs to be in capital letter and you have to write SEARCHWORD. The component is replacing the keyed in text with the SEARCHWORD.