: (match)

returns true where the value of a given field and a given expression partially match syntax expression\ match single word strings do not require quotations multi word strings require quotations field "multi word string" sample usage department\ engineering returns all records where department contains the string engineering department\ eng returns all records where department contains the string `eng` department\ engineering,sales,"customer success" returns all records where department matches any of engineering , sales , customer success department returns all records where department has any value department returns all records where department has no value supported data types anything after the must be a `string` to compare two fields to each other, or to perform an exact comparison, use the = (equals) docid 50o8vwta5zp6sv8dqdwjl operator see also = (equals) docid 50o8vwta5zp6sv8dqdwjl != (not equals) docid\ g6prxutgm2vrcnw7hcqry ! (not) docid\ hdagli50afseam4jx6b8n