Query by wildcard character

WildcardQuery

You can call the WildcardQuery operation to match wildcard characters in a query. You can specify a value to be matched as a string with one or more wildcard characters.

An asterisk (*) represents a number of characters or an empty string. A question mark (?) represents any single character. For example, if you search for string "table*e", you can retrieve query results such as "tablestore." The string specified as a filtering condition cannot start with an asterisk (*).

$request = array(
    'table_name' => 'php_sdk_test',
    'index_name' => 'php_sdk_test_search_index',
    'search_query' => array(
        'offset' => 0,
        'limit' => 2,
        'get_total_count' => true,
        'query' => array(
            'query_type' => QueryTypeConst::WILDCARD_QUERY,
            'query' => array(
                'field_name' => 'keyword',
                'value' => 'key*'
            )
        ),
        'sort' => array(
            array(
                'field_sort' => array(
                    'field_name' => 'keyword',
                    'order' => SortOrderConst::SORT_ORDER_ASC
                )
            ),
        )
    ),
    'columns_to_get' => array(
        'return_type' => ColumnReturnTypeConst::RETURN_SPECIFIED,
        'return_names' => array('keyword')
    )
);
$response = $otsClient->search($request);