如何在选择查询中拆分列及其值

我有一个由用户选择的列及其值的数组。我需要根据这些列和值执行搜索。

例如，用户选择:

morning(column) => thursday,Sun(values)
afternoon(column) => Sat(values)

现在，我如何搜索与列和值匹配的记录?我使用PDO。

数组:

//列

var_dump($cols);
 array (size=3)
      0 => string 'morning' (length=7)
      1 => string 'morning' (length=7)
      2 => string 'afternoon' (length=9)

var_dump($days);

//值

array (size=3)
  0 => string 'Thrs' (length=4)
  1 => string 'Sun' (length=3)
  2 => string 'Sat' (length=3)

Sample列和值存储在数据库中，用于记录。因此，我想使用上述日期和列作为搜索条件。

在下面的记录中，这个用户有

'morning' => string 'Thrs' 
'afternoon' => string 'Fri,Sat' 
'evening' => ''

我的早晨搜索条件是，星期四和太阳。但是这个用户只在星期四早上可用。符合so1标准

下一个是下午，这个用户在星期五，星期六可用。但是我的搜索只需要星期六。因为满足任何一个，所以满足这个条件。

但是假设我的搜索条件是晚上，而不是早上和下午。那么这个用户将不会被选中，因为他/她晚上没空。

希望你能理解这是怎么回事，如果不明白，请随时提问。谢谢你。

array (size=1)
  0 => 
    array (size=25)
      'postUUID' => string '5623853773026' (length=13)
      'subid' => string '36' (length=2)
      'subname' => string 'Muay Thai' (length=9)
      'catID' => string '4' (length=1)
      'catname' => string 'Martial Arts' (length=12)
      'pricing' => string '200' (length=3)
      'post_status' => string '0' (length=1)
      'UUID' => string '562385374bddf' (length=13)
      'Name' => string 'Kalaivani Nair' (length=14)
      'Phone' => string '012345666' (length=9)
      'Email' => string 'kalaivaninair@ymail.com' (length=23)
      'location' => string 'kajang' (length=6)
      'lat' => string '2.993518' (length=8)
      'lon' => string '101.7874058' (length=11)
      'DateReg' => string '2015-10-18 19:40:39' (length=19)
      'Reputation' => string '0' (length=1)
      'ReviewPlus' => string '' (length=0)
      'ReviewNeg' => string '' (length=0)
      'Sex' => string 'f' (length=1)
      'centre' => string '0' (length=1)
      'morning' => string 'Thrs' (length=4)
      'afternoon' => string 'Fri,Sat' (length=7)
      'evening' => string '' (length=0)
      'catid' => string '4' (length=1)
      'distance' => string '0' (length=1)

根据steve的回答编辑

    "avail":["Wed-2","Wed-3"]//JSON string
   $data = json_decode($return, true);//decoded
  $avail = $data['avail'];//stored into database
      if($avail != ""){
        foreach($avail as $k=>$v)
        {
            echo $v;
            $array = explode('-', $v);
            $day =$array[0]; // Languages
            $column =  $array[1]; // English
            echo"<br/>";
            if($column == 1)
            {
            $col = "morning";
            }
            if($column == 2)
            {
                $col = "afternoon";
            }
            if($column == 3)
            {
                $col = "evening";
            }
             echo $col ."=>". $day;
            echo $sql=" SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(('$lat' - lat) *  pi()/180 / 2), 2) +COS('$lat' * pi()/180) * COS(lat * pi()/180) * POWER(SIN(('$lon' - lon) * pi()/180 / 2), 2) ))) as distance  
    from posts,subjects WHERE ('posts.".$col."' LIKE '%".$day."%') AND posts.catID = '$catid' AND posts.subname LIKE '%$subject%' AND posts.subid = subjects.subid AND posts.catID = subjects.catid  AND posts.pricing <= '$rate'  having  distance <= '$distance' order by distance ";
    echo"<br/>";
            // array_push($cols,$col);
            // array_push($days,$day);
        }
        }
            $stmt =connection::$pdo->prepare($sql);
            $stmt->execute();
    $place=array();
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { 
                   $place[] = $row;
                   }

SELECT * FROM `tableName` WHERE (`morning` LIKE '%Thrs%' OR `morning` LIKE '%Sun%');

SELECT * FROM `tableName` WHERE (`afternoon` LIKE '%Fri%' OR `afternoon` LIKE '%Sat%');