Re: question on SELECT using LIKE

Prueba lo siguiente:

SELECT t1.name, t2.group
FROM table1 t1, table2 t2
WHERE t2.namelist LIKE '%' || to_char(t1.name) || '%';

----- Original Message -----
From: "Aggarwal , Ajay" <ajay(at)crossbeamsys(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, November 02, 2000 5:32 PM
Subject: [GENERAL] question on SELECT using LIKE

> Please respond to ajay(at)crossbeamsys(dot)com since I don't subscribe to the
> mailing list.
>
> I have 2 tables :
>
> Table1
> Name Age
> joe 23
> mark 25
> linda 22
>
> Table2
> NameList Group
> joe group1
> mark group2
> joe linda group3
>
> For each person in Table1, I want to list the groups that he/she is a
member
> of. Table2 has the group membership information, but notice that the
first
> column of Table2 is a list of names rather than a single name.
>
> I want to be able to use the the following SELECT call :
>
> SELECT t1.name, t2.group
> FROM table1 t1, table2 t2
> WHERE t2.namelist LIKE %t1.name%;
>
> But its not working. The problem is in '%t1.name%', the second operand of
> LIKE.
>
> Thanks in advance. Please Cc your reply to ajay(at)crossbeamsys(dot)com as well.
>
> Ajay
>