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

[TeeSee1]

You cannot do it with one expression.

You can build a table that meets your requirement by this technique.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-row-per-value-in-EnumList/m-p/357133