SQL Statement NOT Producting Proper Results

I can not find out the answer how to search for something like the following:
SELECT FROM Table where COLUMN IN (a, B).

What I want is to select from the table where Column is a subset of a AND b. Since the IN clause says column = a or column = b, I want column = a also column needs to b. The problem with using regular AND statements is that the COLUMN can have multiple fields.

Example imagine a List with (a, b, c, d, e) and the data is populated with rows like 1a, b, d), 2: (a, c, d)

So if query the following SELECT FROM Table WHERE column = a and column =b. I should get back only "1" record and not "2" record. I don't get back anything. Because 1 = a and b and d.

How do I execute this type of query

[Xnuiem]

I would just use regular and/or statements for this one. Espeically since MySQL does not support subselects from results.

I could give an example but I would like to see a dump of your table and what you are trying to get without the generic stuff since there appear to be some confused terms that are really making it hard for me to understand what you are after.

[gesf]

Hey Dawuad,
Not sure about what you want to do, but... take a look at this link, it may help you!

Cheers

Xnuiem, what do you mean by that? Thanks for you help gesf, but I am looking for subselects like Xnuiem suggested.

[Xnuiem]

The catch is that MySQL doesnt support subselects like Oracle or some of the larger SQL databases. It is supposed to in an upcoming version.

If you can, can you post your table(s) and data so I can run them into a database and figure out a solution for ya. I think I know what you are after, but I personally work better with examples.