Using the CONTAINS function with PartiQL for DynamoDB - Amazon DynamoDB
SyntaxArgumentsReturn typeExamples
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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')