[sqlite] Select name if exists in the group/table

[Micro Mega Dust]

Hi,

I'm a novice using databases, and I have a doubt about the working of
SQL language: I have a system of user group, where each group is a
table in sqlite_master, (each table of a group contains the UIDs of
the members). But I don't know how to get the groups of a user, in a
single query.

I tried this:
SELECT name FROM sqlite_master WHERE 'foo' IN name /* foo is a UID */;

But don't work, "name" is used like a literal value.
Is possible? Thanks!

P.D.: I using SQLite version "2.8.17".

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------