String Compare APIs includes a group of functions that compare the value of string to the given character pattern. The functions are originated from the usage of Database SQL string operators: =/!=, IN, LIKE, and NOT.
- string_equal() performs comparison and returns true if two strings are exactly same.
- string_in() determines if the input string matches any value in a list.
- string_like() determines whether the input string matches a specific pattern that includes wildcard character.
- “%abc%”: input string contains ‘abc’ at any position.
- “abc%”: input string starts with ‘abc’.
- “%abc”: input string ends with ‘abc’.
Meanwhile, the negation of above three functions are also provided.