我是SQL新手.我正试图在WHERE in语句中传递一个列表.但这些值位于类似以下内容的字符串中:
'["id1", "id2", "id3", "id4", "id5", "id6"]'
WHERE IN语句不接受字符串,但接受它:
WHERE IN (SELECT ids FROM unnested_id_related.id_related)
我可以使用UNNEST语句获取此表
CROSS JOIN
unnest(ids) AS unnested_id_related (id_related)
但值ids
需要是一个array.有人知道如何将字符串转换为数组吗?还是在WHERE in语句中传递此字符串的更好方法?