char_matchcount

Updated on 2023-10-25 GMT+08:00

This parameter is used to return the number of characters in str1 that appear in str2.

Syntax

char_matchcount(string <str1>, string <str2>)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

str1, str2

Yes

STRING

str1 and str2 to be calculated

Return Values

The return value is of the BIGINT type.

NOTE:

If the value of str1 or str2 is NULL, NULL is returned.

Example Code

The value 3 is returned.

select char_matchcount('abcz','abcde');

The value NULL is returned.

select char_matchcount(null,'abcde');
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback