This is my document in DB
{
“msgCd”: “Test”,
“contents”: [
{
“langCd”: “en-US”,
“content”: “Introduction: \n “Triple Faces” is a kind of Chinese traditional leisure.”
},
{
“langCd”: “ja-JP”,
“content”: null
}
]
}
This is my query
SELECT msgCd, contents FROM mcms where any content in mcms.contents satisfies content.content LIKE “%Introduction%” END
How even it returns no record to me.
It only works if I change it from “%Introduction%” to “%Introduction%\n%”
I tried the below REGEXP, and still no document that contains “\n” return, would you please help ? any content in mcms.contents satisfies REGEXP_LIKE(content.content, ‘(.*)Introduction(.*)’ ) END