拆分PostgreSQL查询过滤 [英] Split PostgreSQL Query filtering

问题描述

我想过滤学生选择的课程，我的数据是这样的。

I want to filter the course matery is taken by students, my data like this.

select * from course;

并显示这样的数据

+----+-------+----------+-------+
| id | name  | idcourse | status|
+----+-------+----------+-------+
|  1 | Udin  | 1, 5, 8  |    OK |
|  2 | Udin  | 2, 4, 1  |    OK |
|  3 | Mamat |    1, 8  |    OK |
+----+-------+----------+-------+

如何执行查询？
示例

how to perform the query? example

select * from course where idcourse=8;

，并显示记录1和3。

推荐答案

select *
from course
where '8' = any (string_to_array(replace(idcourse,' ',''), ','))

这篇关于拆分PostgreSQL查询过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！