Using the CONTAINS Function with PartiQL for DynamoDB - Amazon DynamoDB

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