Using the CONTAINS function with PartiQL for DynamoDB - Amazon DynamoDB
SyntaxArgumentsReturn typeExamples
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Using the CONTAINS function with PartiQL for DynamoDB

Returns TRUE if the attribute specified by the path is one of the following:

  • A String that contains a particular substring.

  • A Set that contains a particular element within the set.

For more information, see the DynamoDB contains function.

Syntax

contains( path, substring )

Arguments

path

(Required) The attribute name or document path to use.

substring

(Required) The attribute substring or set member to check for. For more information, see the DynamoDB contains function.

Return type

bool

Examples

SELECT * FROM "Orders" WHERE "OrderID"=1 AND contains("Address", 'Kirkland')