"Like" operator is used for pattern matching and have numerous use cases: Warning |
---|
"%" will be used as a wildcard to represent any sequence of characters, and the "_" represents a single character. |
The following is the list used:
![](/community/download/attachments/208701770/image-2023-11-29_10-33-15.png?version=1&modificationDate=1701225198000&api=v2) Wildcard at both ends Return all rows where selected field column value contains the specified "words" anywhere within. Following example return all rows where string of "description" column contains "50". ![](/community/download/attachments/208701770/image-2023-11-29_9-44-20.png?version=1&modificationDate=1701222263000&api=v2)
Result: ![](/community/download/attachments/208701770/image-2023-11-29_10-48-9.png?version=1&modificationDate=1701226092000&api=v2)
Wildcard at beginning Return all rows where selected field column value ends with the specified characters. Following example return all rows where "description" column ends with "0". ![](/community/download/attachments/208701770/image-2023-11-29_10-37-41.png?version=1&modificationDate=1701225463000&api=v2)
Result: ![](/community/download/attachments/208701770/image-2023-11-29_10-48-44.png?version=1&modificationDate=1701226127000&api=v2)
Wildcard at ending Return all rows where selected field column value starts with the specified characters. Example return all rows where "description" column starts with "D". ![](/community/download/attachments/208701770/image-2023-11-29_9-54-20.png?version=1&modificationDate=1701222863000&api=v2)
Result:
![](/community/download/attachments/208701770/image-2023-11-29_10-51-1.png?version=1&modificationDate=1701226264000&api=v2) Single character wildcard Returns all rows where selected field column value matches the specified rules Example return all rows where "description" column contains "T__0" (3rd & 4th character can be anything). ![](/community/download/attachments/208701770/image-2023-11-29_10-17-12.png?version=1&modificationDate=1701224235000&api=v2)
Result: ![](/community/download/attachments/208701770/image-2023-11-29_10-51-41.png?version=1&modificationDate=1701226304000&api=v2)
|