1.SELECT a.* from tablea a INNER JOIN (select regexp_split_to_table('a,b',',') line) tt
on a.id=tt.line;
regexp_split_to_table:可以把字符串分解成表,比in查询快速高效
1.SELECT a.* from tablea a INNER JOIN (select regexp_split_to_table('a,b',',') line) tt
on a.id=tt.line;
regexp_split_to_table:可以把字符串分解成表,比in查询快速高效