我注意到name属性是一个数组而不是对象.因此，您需要在sql中使用join.

I noticed that the name property is an array not an object.So, you need to use join in sql.

SELECT s.label, s.name , name._value FROM s 
join name in s.name
where CONTAINS(LOWER(name._value), "cara") AND s.label = "site"

输出:

希望它对您有帮助.