I cant to get list of values from list of values )

[antimixer]

Hi!
How to do..

Ihave table with "client_preferences", there is columns - "Client" (text), "Preferences" list of values [red , blue , green]

I need to get list of Clients who prefer red or blue. Some Clients have all this values.
I need the list where if client prefers RED and BLUE = its will be 2 records in table how:

Client_A | Red
Client_A | Blue
еtс.

I tryed many variants of SELECT.. IN.. IF.. but cant find how organize this. Please help me write expression