如何在SQL查询中添加带有嵌套的where子句？

这回答了您的问题：

SELECt * FROM  (SELECt unnest(string_to_array(news_article.news_category_id, ',')):: int rowz   FROM news_article) AS categoriesWHERe rowz = 1;

诀窍是

unnest

但是，结果看起来很愚蠢。您是否想要新闻文章的所有详细信息，这些新闻中

news_category_id = 1

SELECt a.*FROM news_article aJOIN (SELECt id, unnest(string_to_array(news_article.news_category_id, ',')):: int rowz      FROM news_article) AS c ON c.id = a.idWHERe c.rowz = 1;