sql - PostgreSQL 通配符 LIKE 用于子查询返回的任何单词列表

Question

这很像 PostgreSQL wildcard LIKE for any of a list of words ，除了不想匹配静态单词列表，我想匹配子查询返回的单词列表。

像这样:

SELECT *
FROM people
WHERE name ~* (SELECT concat(last_name, ', ', first_name) 
               FROM other_people) + wildcard in this direction

Answer 1

select *
from people
where name like any (
    select concat(last_name, ', ', first_name, '%')
    from other_people
)