Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Using the CONTAINS function with PartiQL for DynamoDB

Focus mode
Using the CONTAINS function with PartiQL for DynamoDB - Amazon 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')
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.