Using the BEGINS_WITH 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 BEGINS_WITH function with PartiQL for DynamoDB

Returns TRUE if the attribute specified begins with a particular substring.

Syntax

begins_with(path, value )

Arguments

path

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

value

(Required) The string to search for.

Return type

bool

Examples

SELECT * FROM "Orders" WHERE "OrderID"=1 AND begins_with("Address", '7834 24th')