如何使用PDO从SET类型列返回多个值？

Question

I discovered now that SET is different from ENUM because it allows you to insert multiple values from a list.

So I try to return data from a set column. First of all I create the table "Test_SET_vs_ENUM", than the "ColumnSET"('A','B','C','D') column and after that I inserted in the first row A,B,C

So I try to return data in different ways:

//First try
$sql=$conn->query("SELECT ColumnSET FROM Test_SET_vs_ENUM WHERE IDRow=1");
$result=$sql->fetch();
$conn->exec($sql);
foreach ($result as $content){
echo "Content: ".$content['ColumnSET']."<br/>";
}

And the output is:

Content: A

Content: ,

So I find out that a SET column stored data in form of FirstValue,SecondValue,3Value etc. So when I fetch the result the comma will "end" the array and I will have in the output only the first Value and his comma. This is confirmed by my second try:

//Second try
$sql=$conn->query("SELECT ColumnSET FROM Test_SET_vs_ENUM WHERE IDRow=1");
$result=$sql->fetchAll();
$conn->exec($sql);
foreach ($result as $content){
echo "Content: ".$content['ColumnSET']."<br/>";
}

This time the output was:

Content: A,B,C

But my goal is to have in output each different value, so I tryed this:

//Third try
$sql=$conn->query("SELECT ColumnSET FROM Test_SET_vs_ENUM WHERE IDRow=1");
foreach ($sql as $content){
echo "Content: ".$content['ColumnSET']."<br/>";
}
$conn->exec($sql);

The output is equal to the Second try.

So i'm asking you: How to get the values of a SET column and control each of them separately?

Answer 1

After getting the comma seperated value, you need to explode() it.

Then iterated over this exploded array using foreach() and show them separatly.

Do like below:-

foreach ($result as $content){
  $contents_ids = explode(',',$content['ColumnSET']);
  foreach($contents_ids as $contents_id){
    echo "Content: $contents_id<br/>";
  }
}