查看“数据库函数比较”的源代码

=== MySQL - Doris ===
{| class="wikitable"
|Type
|MySQL
|Doris
|Result
|-
|Json
|select   j1 -> '$."v1"'
from     (
        select   cast('{"v1":"10", "v2":"11"}' as json)  j1
        ) o
<nowiki>;</nowiki>
|
|"10"
|-
|Json
|select   JSON_EXTRACT(cast('{"v1":"10", "v2":"11"}' as json), '$."v1"')
|=
|"10"
|-
|String
|select   trim('"10"', '"')
|=
|10
|-
|
|
|
|
|}