SCONTAINS - String

Checks whether str contains substr

Input parameters

Name	Type	Optional	Description
str	String	False
substr	String	False

Output

Bool: True if str contains substr

Usage

SCONTAINS(<str>, <substr>)

Examples

Example 1

Query

LOAD tmp
AS ('': SCONTAINS("dogsitter", "dog"))

Result

true

Example 2

Query

LOAD tmp
AS ('': SCONTAINS("dogsitter", "cat"))

Result

false